Pivot Tables

[Nadia1182]

Hello All,

I'm trying to figure out how I can get a pivot table to count the number of unique customer names I have in a data set. I don't want a simple count becasue it will count the number of times a customer name appears in the data set I just want to know how many unique customers there are in the data set.

Thanks for your help!

Nadia

 

[Derek Brown]

The following may help:
http://office.microsoft.com/en-us/e...nique-values-in-a-data-range-HP003056118.aspx