How to Use the MIN, MAX, MEDIAN Formula in Excel

You can use MIN and MAX formula to determine the smallest and largest values in a field based on the specified aggregation or grouping. The MEDIAN is the number in the middle of a set of numbers.

This is a very simple and straightforward formula and we’ll have a look at how we can apply it in an example!

Formula:

Formula Explanation

Number1… (required): Number range in which you want to find the maximum, minimum, or median value.

Example:

The General Manager of a second-hand car dealership wants to know the largest, smallest, and median sale of the current year.

The Finance Analyst generates from its Sales Journal the raw data of the dealership’s sales for the current year and uses the MIN, MAX, AND MEDIAN formula to perform the calculation.

Solution:

The results are summarized below. Note that if you wanted to apply conditions to the max and min formula, you would need to use the MINIFS and MAXIFS formula which are part of the next lesson.

*Note this table is only a sample of an example with 5 data entries, and the formulas are based on the whole population of raw data which are not reflected in the example.

Here,

I. MAX(number) formula was used to set a range of data on the sales revenue field to determine the largest value on the field.

II. MIN(number) formula was used to set a range of data on the sales revenue field to determine the smallest value on the field.

III. MEDIAN(number) formula was used to set a range of data on the sales revenue field to determine the median value on the field.

As you can see, this is a very simple formula and is recommended to use rather than sorting data to try and find the min, max, or median.

I hope that helps. Please leave a comment below with any questions or suggestions. For more in-depth Excel training, checkout our Ultimate Excel Training Course here. Thank you!