Excel Forum
Similar Content
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 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 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 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 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.