Find Median of Select Groups

**geddes_3** · 02-18-2014, 06:31 PM

I would like to find the median of certain groups from a large amount of data. I'm looking for a formula that can return the median from certain values in a column, based on values from other columns. The attached example shows what the data looks like, and my desired result. In the example I would like cell G2 to have a formula that looks for all entries of Group A that have a value in Column B, and return the median score from Column D. Is this possible? Median Example.xlsx

**daddylonglegs** · 02-18-2014, 06:37 PM

You can use an "array formula" for this, e.g. in G2

=MEDIAN(IF(A$2:A$100="A",IF(B$2:B$100<>"",D$2:D$100)))

confirmed with CTRL+SHIFT+ENTER

You can amend that as required for G3

**geddes_3** · 02-18-2014, 06:54 PM

Excellent! Thank you!

Find Median of Select Groups

LinkBack

Thread Tools

Rate This Thread

Display

Find Median of Select Groups

Re: Find Median of Select Groups

Re: Find Median of Select Groups

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Median Ifs, need to find median $ amount per deal for each year

Median for Groups in Excel, is there a Function?

How to use median on groups of data

How do find Median of a set of totals and find the relating grade

[SOLVED] Calculate median for different groups

Bookmarks

Bookmarks

Posting Permissions