Increment a duplicate when found

  • Thread starter Thread starter TimEtotTime
  • Start date Start date
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top