Excel Forum

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

Got a Question? Ask it Here in the Forum.