Excel Training: Calculating Highest & Lowest Numbers

If you’ve got a massive list of numbers in Excel – say product prices, or students scores in a test, and you want to find the highest or lowest value – sifting through all of the entries to find it could take hours!

One solution is to sort your data from lowest to highest, but that’s not always a practical option – especially in Excel spreadsheets that hold a lot of other data.

Like this? Check out our top 10 Most Powerful Time Saving Excel Formulas

Luckily – Excel has a function to help you to identify the highest and lowest numbers in a list.

In this short Excel training tutorial we show you how:

Excel Training: Finding Highest and Lowest Numbers:

Lowest number:

The function for finding the lowest number in a list is =MIN()

So – in the cell where you want the answer to be displayed, type in =MIN()

Now – between the brackets – enter the range of cells that you want to search from – e.g B1:B10. If the data isn’t all in one list you can also separate multiple locations with commas – e.g “B1,A1,C10:C15″

Excel-training-highest-lowest-numbers

Highest Number

The function for finding the highest number in the list works in the same way – but the function is MAX.

In our example below, the function to type is =MAX(B10:B15).

Excel-training-highest-lowest-numbers-2

Tags

, , , , , , ,
Andy Trainer


Connect with Andy on Google.

View all posts by Andy Trainer

Leave a Comment