Excel Forum

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.