Top and bottom: LARGE, SMALL, MEDIAN

LARGE(range, 2) is the 2nd biggest, SMALL(range, 3) the 3rd smallest. MEDIAN is the middle value.

4 exercises in this lesson are part of ExcelHero Pro.