Pivot Table Question

[deacs]

I have a data set where one column has a list of different names. In some cases, these names show up multiple times.

Is it possible to create a pivot table that sums up the number of times that each name shows up? I've been trying it in the wizard and have been unable to do anything but count the total number of names in the column.

Thanks in advance!

[VBA Noob]

Hi,

This link may help

http://www.contextures.com/xlPivot07.html#Unique

VBA Noob

[deacs]

Thanks so much for the quick reply. I apologize for being dense, but I am still unable to get it to work right.

If my list of "customers" is in column A, how would use that formula to get unique counts of customers for the pivot table?

Thanks again.

[VBA Noob]

Try

=IF(SUMPRODUCT(--($A$1:$A1=A1))>1,0,1)

VBA Noob

[deacs]

Thanks! It works perfectly!

[VBA Noob]

No problem

VBA Noob