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...
Filter Data in Excel to Display Results that Contain 1 of 2 Possible Values - AutoFilter
Macro: This Excel macro filters data in Excel to display results that contain 1 of 2 possible val...
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 ...



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.