Share via

Excel pivot table - median

Anonymous
2018-06-13T13:30:07+00:00

How can I use a pivot table in Excel to find the median.  I see average and sum, but not median.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2018-06-13T14:11:07+00:00

    Excel itself does not support calculating medians in a pivot table, but see https://www.extendoffice.com/documents/excel/4815-excel-pivot-table-median.html for a trick to work around this limitation.

    7 people found this answer helpful.
    0 comments