Basic Functions
Intermediate
LARGE and SMALL Functions
Find the nth largest or smallest values.
Task:
You are analyzing a dataset to identify extreme values. Find the 2nd largest value in cell B8 and the 2nd smallest value in cell B9 to understand the range and distribution of your data.
Learning Objectives:
- Learn LARGE and SMALL functions
- Understand positional statistics
- Practice advanced data analysis
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | |
|---|---|---|
| 1 | Values | |
| 2 | 45 | |
| 3 | 23 | |
| 4 | 67 | |
| 5 | 34 | |
| 6 | 89 | |
| 7 | 12 | |
| 8 | 2nd Largest | |
| 9 | 2nd Smallest |
What this exercise teaches (contains the answer)
LARGE and SMALL functions help find specific ranked values (e.g., 1st, 2nd, 3rd largest/smallest) in datasets without needing to sort the entire dataset.