AdvancedStatistical Functions
Total the three biggest orders
Add up the top three values without sorting the data or using a helper column.
LARGE
10 min35 points
Name the second-best rep with LARGE and INDEX
The situation
Harbor Supply's incentive scheme pays a bonus to the runner-up as well as the winner. The board pack needs both names, and the list is not sorted.
A1
fx
| Row number | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Rep | Sales | |||||
| 2 | Marcus Bell | $95,000 | Top rep | Dana Whitfield | |||
| 3 | Dana Whitfield | $143,000 | Runner-up | ||||
| 4 | Alan Reyes | $78,000 | |||||
| 5 | Priya Raman | $118,000 | |||||
| 6 | Tomas Iverson | $104,000 | |||||
| 7 |
Functions in this exercise
- LARGE — Returns the nth largest value — the third-best rep, not just the best. Syntax and example
- INDEX — Returns the value at a given row and column position in a range. Syntax and example
- MATCH — Returns the position of a value within a range. Syntax and example
Who this is for
Recommended next
Related exercises
- IntermediateLookup & Reference
Find a value with INDEX and MATCH
Combine INDEX and MATCH to look up a value without a fixed column number.
INDEX · MATCH
10 min25 points - BeginnerStatistical Functions
Find the largest and smallest order
Identify the extremes in a column of values.
MAX · MIN
4 min10 points - IntermediateStatistical Functions
Measure the spread, ignoring the extremes
Compare the second-best and second-worst weeks to get a fairer range.
LARGE · SMALL
7 min25 points