Excel Forum
Similar Content
Dynamic Formulas that Update When you Add Data in Excel
Tutorial: I'll show you how to make formulas and functions that automatically update when more data...
Convert Column Number to Letter Using a Formula in Excel
Tutorial: How to get a column letter from a number in Excel using a simple formula. This is an ...
Dynamic Charts in Excel - The Easy Way
Tutorial: How to create dynamic charts that update automatically when new data is added to Excel. T...

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.