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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to show a count of Unique IDs in a Pivot Table 2
Pivot table calculated field Count(field) / sum(field) 0
Turning Data into a Table 1
Pivot Tables - Unique items 2
count unique dates in pivot 2
Unique Pivot Table Count 1
pivot table calculated field 1
Count of unique values in Pivot Table 1

Top