How to Find a Median in Excel 2010

Excel 2010 is a great tool when you have a lot of data that you want to compare. You can easily perform mathematical operations on numerical values and find answers to questions that could take hours to calculate manually.

You may already know how to add groups of numbers together and divide them, or you might be familiar with how to sort a group of data.

But if you have a number of cells that contain data and you want to find the median value of those cells, then you might have previously resorted to doing this manually.

Fortunately, Excel 2010 can actually calculate the median for a group of data with a simple formula that you can learn how to use below.

Calculating a Median in Excel 2010

The steps below are going to teach you how to type a formula into a cell in Microsoft Excel that will help you find the median for a range of numbers. It will also assume that the cells for which you want to find the median are all consecutively listed in a single column.

Step 1: Open the spreadsheet containing the group of data for which you want to find the median.

Step 2: Click inside the cell into which you want your median value to be displayed.

click inside the cell where you want to display the median

Step 3: Type the formula =MEDIAN(XX:YY) where XX is the first cell in the range and YY is the last cell in the range. You will see your formula displayed in the formula bar above the spreadsheet. Pres Enter on your keyboard when you are finished to execute the formula and display the median value.

how to find the median in excel 2010

Now that you know how to find a median in Excel 2010, you can use this formula in the future when you need to find this type of information for a selection of cells in your spreadsheet.

Do you want to find the average value of a range of cells? Read this article to learn how you can calculate an average in Excel 2010.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy