LARGE and SMALL
Exercise 1 of 3
In F2, find the 3rd highest score.
About this lesson
LARGE and SMALL return the 2nd, 3rd or any other highest or lowest value.
In this lesson
- In
F2, find the 3rd highest score. - In
F2, find the 2nd lowest score. - Which function gives the same result as
LARGE(B2:B9,1)?
Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.
fx
Type in F2 and press Enter to check.