|
Featured Tutorial
Featured Macro
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.
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.