Count Unique records in Pivot table

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
 
D

Dave Peterson

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.
 
Top