+ Reply to Thread
Results 1 to 3 of 3

Find Median of Select Groups

  1. #1
    Registered User
    Join Date
    10-14-2011
    Location
    Utah
    MS-Off Ver
    Excel 2007
    Posts
    25

    Find Median of Select Groups

    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

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Find Median of Select Groups

    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
    Audere est facere

  3. #3
    Registered User
    Join Date
    10-14-2011
    Location
    Utah
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Find Median of Select Groups

    Excellent! Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Median Ifs, need to find median $ amount per deal for each year
    By xenomorph8472 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-13-2012, 02:01 PM
  2. Median for Groups in Excel, is there a Function?
    By ej463 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-11-2009, 06:24 PM
  3. How to use median on groups of data
    By robbo11 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-30-2007, 08:55 PM
  4. How do find Median of a set of totals and find the relating grade
    By whitespaces in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2006, 11:16 AM
  5. Calculate median for different groups
    By Daniel in forum Excel General
    Replies: 2
    Last Post: 01-26-2005, 09:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1