The following step-by-step example shows how to calculate the median value by group in Excel.

**Related:** How to Calculate the Average by Group in Excel

**Step 1: Enter the Data**

First, let’s enter the following dataset that shows the total points scored by various basketball players:

Now suppose we’d like to find the median value of the points scored, grouped by team.

To do so, we can use the **UNIQUE()** function to first create a list of the unique teams.

We’ll type the following formula into cell **E2**:

=UNIQUE(B2:B12)

Once we press **Enter**, a list of unique team names will be displayed:

Next, we can use the following formula to find the median value of points scored by players on each team:

**=MEDIAN(IF($B$2:$B$12=E2, $C$2:$C$12))
**

We’ll type this formula into cell **F2** and copy and paste it down to each remaining cell in column F:

Column E displays each of the unique teams and column F displays the median value of the points scored by each team.

From the output we can see:

- Median value of points for Lakers players:
**16** - Median value of points for Mavericks players:
**25** - Median value of points for Spurs players:
**30.5**

We can verify these results are correct by manually calculating the median for one of the teams.

For example, the points scored by players on the Spurs team is: 14, 28, 33, 35

The median value would be the value directly in the middle of 28 and 33, which is **30.5**.

This matches the value calculated using the formula.

**Related:** How to Perform a Median IF Function in Excel

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

How to Calculate a Five Number Summary in Excel

How to Calculate the Mean and Standard Deviation in Excel

How to Calculate the Interquartile Range (IQR) in Excel

Delete the value in cell C3 and see, how the result changes.

A pure desaster… 🙁