•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
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#median
#mean
#age
#pivot table
#filter tool