Hello,

I have column A with corporate IDs, column B with BAN numbers and column C
with managers (33,510 rows total). All the BANs will be different but
sometimes the corp ID can be the same. I need to be able to do a pivot table
by each manager (50 managers) and count the corp IDs but NOT count any
duplicate corp IDs. For example, for the below sample, the pivot would show
1 for Smith, 1 for Rogers (duplicate corp ID) and 2 for Brown (2 different
corp IDs).

A Corp ID B BAN C Manager

1 GDCCW_USAF_3060_P 431030123 J. Smith
2 GABOC_GS2_3060_P 0624210300 V. Rogers
3 GABOC_GS2_3060_P 431030123 V. Rogers
4 799791314_6021_P 799791314 K. Brown
5 411781312_6021_P 411781312 K. Brown

Thank you!!