find duplicates from a range of data

  • Thread starter Thread starter dk2463
  • Start date Start date
D

dk2463

I have 2 columns of data that look like this:

Service Name
Service A John Doe
Service B Jane Smith
Service C Jane Smith
Service A John Doe
Service D Bill Smith
Service B Jane Smith

I want to find a formula that will look at the data in those 2 columns
then mark the columns where there are duplicates (like John Doe with 2
Service A's and Jane Smith with 2 Service B's) with the word Duplicate
or something like that. Any idea how to do that?

thanks in advance,

Doug K
 
Back
Top