Hello All,

Please see attached sheet,

Sheet 1, Column V is where i would like the formula. Sheet 2 is the reference table

I would like to count the number of unique times that the Cost Center number comes up and ignores duplicates.

For example:
10064 is 1 because the Reference is only AAA00007071
10078 is 2 because the Reference has two unique numbers AAA00006600 and AAA00007170

I manally entered in Column W so you can see what values i'm looking for.

Thanks for the help!Countifs-Unique.xlsx