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