Excel: top values and ranking

Sign up free to unlock this topic

Kindergarten is free, and guests can try one sample topic in every other grade. A free parent or teacher account opens every topic from Kindergarten to Grade 12, college and university, and saves progress. No credit card.

Try the free sample: The ideal gas law · Have a class or homeroom code? Join here

Key idea: Excel: top values and ranking

LARGE(range, k) gives the k-th biggest value and SMALL the k-th smallest. RANK.EQ(value, list) gives a position, 1 for the biggest. To find who has the top value, look up MAX in the numbers and return the name.

Key words

LARGE(…, 2)
Second place.
RANK.EQ
Lock the list with $ before copying.

🔎 What to look for: Ties share a rank.

Zero2Hero — Zéro2Héros