Home » Resources » Excel 2007 Tutorial » Highest and Lowest Numbers

Excel also has functions that you can use to identify the smallest and largest numbers of any group or series of numbers. This is particularly useful if you have a very long list of data, and don’t want to have to read through the whole thing to find the biggest or smallest value.

To find the lowest number in a list, the function is =MIN(). Between the brackets I would type in the range of cells – e.g “B1:B10″ or “B1,A1,C10:C15″

If I wanted to find the highest number instead of typing MIN I would type in MAX, i.e. =MAX(B10:B15).

Similar resources you may like

1. Submitting Information
2. Formatting Numbers
3. Excel Functions
4. Reference Operators
5. The Count Function

Tags

Excel, Excel 2007 Tutorial, excel training, excel tutorial, Free, microsoft, microsoft excel, microsoft office, resource, Tips, top Tips, training

Share This Resource

This entry was posted by Alistair Wylie on Wednesday, May 6th, 2009 at 1:44 pm and is filed under Excel 2007 Tutorial. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.