Excel Forum

Excel Magic Trick # 162: LARGE IF & INDEX w 4 Criteria

See how to how to extract the 10 largest values based on three criteria and then extract the product name for each large sale.
See how to use INDEX and MATCH functions with 4 criteria.
See how to deal with duplicates with the MATCH function by using the COUNTIF function.
See the IF, OR, LARGE, ISERROR, MATCH, INDEX and COUNTIF functions in one array formula.

Got a Question? Ask it Here in the Forum.