Excel 2007 : How to show unique count in excel pivot table

[Nitesh Khot]

Hi..,

I am using excel 2007 and I want to show unique count against emp..ie.

column A contain Emp Name and B contains city (lots of duplicity in city),..If I pivot these value then it showing exact count of city not Distinct unique count...

How to do this using VBA or Formula..

Thanks

 

[Chihiro]

You'd need helper column for source data.

Without knowing your data structure hard to give you exact formula, but follow steps shown in link.

https://www.extendoffice.com/documents/excel/2127-excel-pivot-table-count-unique-values.html