7 Steps To Perfect Formulas PLUS Bonus Cheat Sheet: 15 Of The Best Starter Functions
Enter your details for immediate access
Finding the biggest number within a range of Excel cells is super easy.
Same for picking the smallest number.
There are many situations where you need to find the biggest/smallest, highest/lowest, longest/shortest value in a set of data. For example,
Use the MAX function to find the biggest number in a list (or tallest, longest, most etc.)
=MAX(number1, number 2 …)
Use the MIN function to find the smallest number in a list (or shortest, lowest, least etc.)
=MIN(number1, number 2 …)
The MAX and MIN functions can be selected from the AutoSum drop down menu, or by typing it directly into the cell.
Let’s say you have values in cells A1 to A10,
To use the AutoSum tool:
Using either technique, the final formula will look like:
Did this clear something up for you? If so, please share on your socials and/or post a brief comment below.
Likewise, if something didn't make sense or you have a question, pop it into the comments below. I'll be waiting ...
Cheers. Here's to your learning and success. Enjoy the rest of your day.
Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.