Excel Magic Trick 758: Extract Data With Two Criteria - 5 Formula Methods

Описание к видео Excel Magic Trick 758: Extract Data With Two Criteria - 5 Formula Methods

Download Excel Start File https://people.highline.edu/mgirvin/Y...

Download file: http://people.highline.edu/mgirvin/
See 5 different formula methods for extracting data with two citeria. See functions such as: MATCH, ISNUMBER, OR, LOOKUP, COUNTA, COUNTIF, MAX, INDEX, SMALL, ROW, ROWS, AGGREGATE and more function. Three of the formula work in Xcelsius.
Learn some great things from a Mr Excel Message Board Posts by Aladin and Peter SSs.

Also see:

Excel Magic Trick 758.5: Extract Data With Four Criteria VLOOKUP & INDEX SUM, AND, OR Functions

Комментарии

Информация по комментариям в разработке