Loading…
Loading…
MIN and MAX return the smallest and largest number. LARGE and SMALL return the nth largest or smallest, so LARGE(range,2) is the runner-up.
Syntax
MIN(range) · MAX(range) · LARGE(range, k) · SMALL(range, k)
Example: =MAX(B2:B6) is the top score. =LARGE(B2:B6,2) is the second-highest.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.