Excel Forum

Excel Magic Trick 185 Dynamic Formula Extract Data 1criteria

Create a formula to extract part of a table from a larger table. Similar to a query in Access, but with a array formula in Excel that uses the functions: INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW. This formula will extract records that meet one condition (criteria criterion) and list them in order with no extra rows between records. We will also use the INDIRECT function to save on formula creation time.
Related Videos:
YTLE#84: A Few Data Validation Tricks
Excel Magic Trick #180: COUNTIF function formula 21 Examples
04 Excel Series: Names 1-12
Excel Name Trick #7: INDIRECT function, Names and LOOKUP
05 Excel Series: Array Formulas 1-14
Various INDEX Lookup w TRUE/FALSE criteria "Reverse Lookup"
Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria
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.