|
Featured Tutorial
Featured Macro
Excel Magic Trick 758: Extract Data With Two Criteria - 5 Formula Methods
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
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