find duplicates from a range of data

[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

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates

 

[sandra]

Check out http://www.cpearson.com/excel/topic.htm under
duplicate entries.

If that doesn't do it for you, I've got a VB solution
that'll work.