Excel Forum

Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria

This formula will extract records that meet two conditions (criteria) and list them in order with no extra rows between records. Create a formula to extract part of a table from a larger table based on two criteria. Similar to a query in Access, but with a array formula in Excel that uses the functions: IF, ROWS, INDIRECT, COUNTIF, INDEX, SMALL, and ROW.

Related Videos:
Excel Magic Trick #180: COUNTIF function formula 21 Examples
05 Excel Series: Array Formulas 1-14
Various INDEX Lookup w TRUE/FALSE criteria "Reverse Lookup"
Excel Magic Trick 185 Dynamic Formula Extract Data 1 criteria
04 Excel Series: Names 1-12
Excel Magic Trick #187: Unique List w Dynamic Formula
Excel Magic Trick #81: Advanced Filter AND OR Data Extract

Got a Question? Ask it Here in the Forum.