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 ...
The Magically Appearing Cell in Excel
Tutorial: A fun way to make a cell's contents appear when a specific action occurs. This works when...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.