Getting a total in a pivot table, excluding the duplicates.
 

I had following formula to give me the count of the single instances
of a repeated name.
I am trying to upgrade my report and use a pivot table, but wonder how
to use this formula/or a simpler way to count only the unique instance
in a column/header.

Any advice?

=SUM(IF(FREQUENCY(IF(LEN(B:B)0,MATCH(B:B,B:B,0)," "),
IF(LEN(B:B)0,MATCH(B:B,B:B,0),""))0,1))


Example:
Names in column A.
Codes in column B.
Some of the codes in column B are repeated.
In my pivot, I want to roll up how many codes (excluding the
duplicates) each person had.