Thank you. The piece I am not clear on is how to create the formula without
hard coding the params. The data I need to use to identify the median is in
2 columns - column A has job title and column B has salary - there are
approximately 1000 different job titles that I need to find the medians for.

"Max" wrote:

One way to get at it is via using conditional, array-entered* expressions
like this:
=MEDIAN(IF((A$2:A$10="Dept1")*(B$2:B$10="Assoc"),C $2:C$10))
*press CTRL+SHIFT+ENTER to confirm the formula(not just ENTER)

The above derives the median salary of staff of rank: Assoc in Dept1,
assuming col C houses the salary data. You can point to cells housing the
various params for dept and rank (eg params in 2 cols) instead of it being
hardcoded in the example, and hence easily propagate the expression down to
derive all the various results.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"SB Lee" wrote:
I am summarizing a large amount of compensation data using pivot reports and
need to include the median. I do not think median is available for use in
pivot tables or when even just subtotaling data - what would be the best way
to quickly find medians for many different groupings in a large amount of
data?