• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 812
  • Last Modified:

Pivot Table to count unique ids - Excel 2007

Is there a way to create a pivot table which just counts the number of unique ids.
0
morinia
Asked:
morinia
1 Solution
 
Elton PascuaCommented:
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

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now