So you're looking to count unique entries?

Maybe using this technique from Debra Dalgleish's site would work:
http://contextures.com/xlPivot07.html#Unique



christabbie wrote:

I would like to accomplish this same thing in a pivot table. Any advice on
doing that - if I can piggy-back on your question? :)

Christa

"mrsmasterg" wrote:

I have a spreadsheet in which duplicate data appears multiple times in
groups. I would like to count each occurence. Ex.
12345
12345
12345
12345
78912
78912
78912
78912
78912

expected result is that each occurence is counted once.
12345 occurs once
78912 occurs once

I do not want to use a pivot table because each 'group' has multiple rows of
data that needs to be shown.

--

Dave Peterson