Main Profile

At A Glance

Excel Magic Trick 409: VLOOKUP MAX Value, Return More Than 1 Record

See how to find the Max statistics in each category and return the names associated with those stats, even when there are duplicates. See the COUNTIF, MAX, IF, ROWS, INDEX, SMALL and ROW functions in an array formula. Lookup one value and return duplicates.
Length: 10:14

Contact

Questions about Excel Magic Trick 409: VLOOKUP MAX Value, Return More Than 1 Record

Want more info about Excel Magic Trick 409: VLOOKUP MAX Value, Return More Than 1 Record? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question