Distinct Count Function for Mac!

[kinan334]

Hi everyone,

I was using the distinct count function in pivot tables so it doesn't count duplicates.
To have it available, the flag "add this data to data model" must be marked when inserting the pivot table from the data source.
This has always been very helpful to me.

I am using Mac now, and i am aware that the data model is not available, so i can't use the distinct count feature.

Is there any way around so i can have a pivot table not counting duplicates?

Thanks in advance!

 

[James006]

Hi,

Debra has designed an excellent solution :

https://www.contextures.com/pivottablecountunique.html

Hope this will help

 

[kinan334]

I used the COUNTIF method with some variations.

This helped a lot.

Thanks!

 

[RoryA]

Please take a minute to read the forum rules on cross-posting (they are much the same on most forums) and follow them in future please.

 

[kinan334]

My apologies. I needed the answer shortly and i kind of freaked out.

I didn't know about crossposting rules, but i know now, and i fully agree with them.

Regards and thanks again.