I just purchased the latest MS Office subscription for Mac, specifically so I could access the latest version of Excel so that I could use distinct count in pivot tables. But it does not appear in the "Summarize by" dialogue box as a choice. Any advice? Is is available as an add-on by any chance? Thanks for any help
Have you tried Debra's workarounds
http://www.pivot-table.com/2012/02/2...th-powerpivot/
One other way you could consider would be to build an extra column into the data rows which calculate the unique occurrencies of each item. Then either accept that there will be many occurrencies of the unique number for each item or modify the count formula to only show the first unique count value. Then include this additional column in a regular Pivot Table.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks - so I'm really out of luck with this function? Why does Excel 2013 for PCs has it but not my (even later) version? I was hoping not to have to take these extra steps
Are we talking about DISTINCT values or UNIQUE values here ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks