We help IT Professionals succeed at work.

Pivot Table to count unique ids  - Excel 2007

morinia asked
Is there a way to create a pivot table which just counts the number of unique ids.
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.


Open in new window

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