Count Unique records in Pivot table

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Hi All,

I have spreadsheet full of data and one of the fields, "chassis", has
the chassis repeated down the list more than once.

Is there anyway that when I'm in the pivot table I can count unique
records rather than just count ?


Adam
 
You could add an additional column to your data table. Put a formula like:

=IF(COUNTIF($A$2:$A2,A2)=1,1,0)

And drag down.

The formula for the initial entry will evaluate to 1. The remaining will be
0's.
 
Back
Top