We help IT Professionals succeed at work.

Pivot Table to count unique ids  - Excel 2007

morinia
morinia asked
on
Is there a way to create a pivot table which just counts the number of unique ids.
Comment
Watch Question

Yes. Add a column to the Pivot Source, and put the formula below. Change the ranges accordingly to what you're checking for uniqueness.

Add as a field to your pivot table with Sum calculation.

=IF(COUNTIF($I$1:I2,I2)=1,1,0)

Open in new window

Explore More ContentExplore courses, solutions, and other research materials related to this topic.