View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SB Lee SB Lee is offline
external usenet poster
 
Posts: 1
Default Median Calculation

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?