Podium: the largest and the smallest

Find the middle value and build a podium.

MEDIAN shows the middle value of the list. If you line everyone up from smallest to largest, it's the one in the middle. LARGE(list, 1) shows the 1st largest, LARGE(list, 2) the 2nd largest, and so on. Perfect for a podium! SMALL(list, 1) does the same, but starting from the smallest.

Module: Tricks with numbers. Lesson 33 of 62.

• Previous lesson: Day of the week and due dates
• Next lesson: RANK: who finished where
• All lessons