How to Find Midrange Using Windows Excel

Excel has a number of functions for extracting a given number out of a range of numbers. Examples include the =MIN() function (which takes the smallest number in the range) and the =MAX() function (which takes the largest number in the range). Getting the middle value out of a range of numbers uses the =MEDIAN() function, and is useful for finding data in ranges with a few outliers on the high or low values, such as finding out what a typical midrange sales volume is like on a day in November, not counting sales on the day after Thanksgiving.

Businesswoman using laptop computer
credit: Jupiterimages/Pixland/Getty Images

Step

Open up your Excel file with your range of numbers. For this example, put your numbers in cells A1 through A10.

Step

Enter the formula "=MEDIAN(A1:A10)" in cell B1.

Step

Press "Enter" to allow the formula to run. The middle value in the range of cells will be displayed.