Feedback by UserVoice

How can we improve Excel for Mac?

Median function on Pivot Tables

Please add a median function for Pivot Tables. It is mind boggling how Google Sheets has this capabilities but the much more powerful MS Excel does not

139 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

6 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Dalton commented  ·   ·  Flag as inappropriate

    For the love of God add this, it's 2019. Google Sheets has it, it's a better measure than average, and it takes way too **** long to work around it.

  • Alan Moorse commented  ·   ·  Flag as inappropriate

    The Median function is absolutely needed in pivot tables. Without it there, the user is left with complex, slow, unwieldy work-arounds.

  • Neil Garrett commented  ·   ·  Flag as inappropriate

    The Medium is used as standard average across the public sector in the UK. Sometimes it is used alongside the mean to demonstrate the variance of individual data on the whole. An example would be the Gender Pay Legislation which requires large employers in both the public and private sector in the UK to produce data on gender pay gaps. Often one high paid male employee could be an outlier that has a dramatic impact on the average. Working medians outside of pivot tables is long-winded, especially if you are tasks with continually reviewing smaller datasets and cutting the data in various ways.

Feedback and Knowledge Base