•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Finding the median and the mean age from a pivot table when I have the counts
Hello, I'm working. on a project where I'm trying to find the median and mean age for a specific group (that has been filtered using the filter tool) in a pivot table. My data has been sorted in a way (using the Summarise values by Count tool) where I can see the counts for each age. I'm unable to get to the mean or the median for this. See example image below.
[link] [comments]
Want to read more?
Check out the full article on the original site