Excel Forum

Excel Magic Trick #131: Ranking w MIN IF OFFSET

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.

Got a Question? Ask it Here in the Forum.