Forum Discussion

Copper Contributor

Nov 27, 2023

distinct values in pivot table on excel for Mac

Hello, there is no function on Mac Excel to get unique/distinct values when using a Pivot table to get data reports. Please help! Thanks

Formulas and Functions

Copper Contributor

Nov 27, 2023

Hello there Riny, thank you. So what is the solution/way around this?
Thanks

MVP

Nov 27, 2023

Workaround is the helper column in source data, see for example Excel PivotTables Unique Count 3 Ways • My Online Training Hub

Share

Resources