🏅 Ranking Finder

Goal: Find specific ranked values (e.g., 2nd Highest, 3rd Lowest).
LARGE: Top-down ranking. SMALL: Bottom-up ranking.

🥈
-
2
🥇
-
1
🥉
-
3
Data Set: { 10, 50, 85, 90, 20 }
Ready...

💻 Formula Structure

=LARGE(array, k)
  • 1. Array: The data range.
  • 2. K: The position to find (1 = Max, 2 = 2nd Largest, etc).
-- Select a ranking...
...
Value Found:
-

⚠️ Common Pitfalls

🚫 K > N Error
If you have 5 items and ask for the 6th largest (K=6), Excel returns a #NUM! error. You can't rank what doesn't exist.
✅ Duplicates Count
If your data is {10, 10, 5}, the 1st Largest is 10, and the 2nd Largest is ALSO 10. They take up two ranking spots.