Main Profile

At A Glance

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.
Length: 10:21

Contact

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

Want more info about Excel Magic Trick # 162: LARGE IF & INDEX w 4 Criteria? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question