Excel: Using the MAX() and MIN() Functions

Want to find the highest or lowest values in the a range in Excel? Then there are two functions that are easy to use to do that. They are MAX(), for finding the highest, or maximum value, and you guessed it MIN() for finding the lowest or minimum value.

If you are looking to find other high or low values like the second or third highest or lowest, or any other within a range then you are after the LARGE() and SMALL() functions, you can check that out by clicking here.

Here is a video I made to show how MAX() and MIN() both work.

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, excel function, Excel Functions, Microsoft 365, Microsoft Office and tagged , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s