Hi,

I have a large list - and was wondering how to count unique numbers (eg.
customer IDs) in a pivot table.
I have arranged my data so each location is shown in the rows.

Can this be done? So far I can only get the data field to count the total
entries, but not unique entries by location.

If not - is there a way to do this with a formula?

Any help appreciated.

Nelson