Find the best month with MAX
PremiumIn E2, use MAX to find the highest sales figure in B2:B6.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Region | Sales | ||||
| 2 | North | 18200 | Best | |||
| 3 | South | 22950 | ||||
| 4 | East | 19400 | ||||
| 5 | West | 24100 | ||||
| 6 | Central | 21300 | ||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock MIN, MAX and LARGE and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
Next with premium:ROUND, ROUNDUP and ROUNDDOWNRelative and absolute references
It comes up in this mock test: Excel assessment (Indeed format)
Your first month for $9.50 $19
50% off your first month when you join today.
Get your first month for $9.50
Already premium? Sign inThen $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.
Need help?
Why this works
MAX returns the largest number in the range and ignores text and blank cells. Here it is West with 24,100.
Common mistake: Sorting the list to find the top figure. MAX gives the answer without changing the data, and it updates when a figure changes.
The answer
- E2
=MAX(B2:B6)