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.
