See the functions COUNTIF, MIN, IF, OFFSET, VLOOKUP functions formula used in a table to complete a complex ranking. Other Excel concepts: 1) See how to change the calculation at every change in a sorted list, and 2) How to use OFFSET to change the range for your function.
Questions about Excel Magic Trick #131: Ranking w MIN IF OFFSET
Want more info about Excel Magic Trick #131: Ranking w MIN IF OFFSET?
Get free advice from education experts and Noodle community members.