Pivot tables to count unique records only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I have some data which is sometimes repeated. I want this data to feed
directly into a pivot table and only count the unique records as theres
records in there which appear about 8 times.

When you do count on a reference number it counts it each time, show its
showing about 131 records when its truly 22 !

Can anyone help please?
 
A pivot table won't calculate a unique count. However, you could add a
column to the database, then add that field to the pivottable.

For example, if you want to count the customers in column A, use the
following formula in row 2:
=IF(COUNTIF(A$2:A2,A2)=1,1,0)

Copy this formula down to all rows in the database.

Add this field to the pivot table data area, as a Sum, and you'll get a
count of unique items.
 
Back
Top