Excel Forum
Similar Content
Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
Macro: This free Excel macro filters data in Excel based on multiple criteria for one field in th...
Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
Macro: This Excel macro allows you to filter a data set on multiple columns and criteria at once....
Filter Data in Excel Without the Filter "Arrow" Appearing in the Filtered Column - AutoFilter
Macro: This Excel macro filters data in Excel without the filter "arrow" appearing in the column ...

Excel Magic Trick 574: Array Formula For Filtering Data With Categories of Criteria

See how to streamline filtering when you have categories of criteria using an array formula that uses the functions: COUNTIF, VLOOKUP, ROWS, IF, INDEX, SMALL, ROW. Also see how to put OR criteria into the IF function and see how to do an Or Count using two COUNTIF functions.

Got a Question? Ask it Here in the Forum.