Could use some help. I am trying to calculate the median age based on 2 different columns. The first column is the "Site" and the second is the "Issue Type".
Thus, the goal would be for each site, list its median age for each issue type.
Attached is the sample data.
Would greatly appreciate the help!
Here's one way:
Copy column A and B to columns E and F. Highlight columns E:F > Data > Remove Duplicates
G2 =MEDIAN(IF((A$2:A$19066=E2)*(B$2:B$19066=F2),C$2:C$19066)) Ctrl Shift Enter
Drag the formula down column G.
Re: Calculate Median based on multiple conditions
something like this one?
Similar to 63falcondude's solution:
Do the remove duplicates step.
In G2 this formula can be committed with just Enter and filled down.Formula:
Please Login or Register to view this content.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks