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.