Increment a duplicate when found

T

TimEtotTime

I have a list of non-unique id references in column A and a list of
Non-Unique Phone Types in column B. (e.g "Business")What I need to do
is: find where a duplicate is found from matching info in col's A & B.
Where that is True I need to increment the Phone Type by 1, leaving
"Business,Business1,Business2 etc

So I end up with a unique Phone Type for each person.
 
D

Dave Peterson

Headers in Row 1???

I put this in C2 and dragged down.

=B2&SUMPRODUCT(--($A$2:$A2=A2),--($B$2:$B2=B2))

It seemed to work ok in my simple test data.
 
Top