Debra Dalgleish shares a technique:
http://contextures.com/xlPivot07.html#Unique

ceh4702 wrote:

In a Pivot Table I am summarizing the Data by Name/ID of the person and each
person may have multiple records. When I count a field like ID I get like 1,
4 or 2 for each person. However, what I want to count is the number of
people, even though their are multiple records. Is there a way to count a
field and skip the duplicated?

--

Dave Peterson