Return a value based on duplicate names

  • Thread starter Thread starter Jimmy H
  • Start date Start date
J

Jimmy H

Hi.

I have a list of names, some of the names are duplicated. I need a formula
or function that will recognize this and make the identical names stand out,
by either bolding the name, highlighting the cell, or putting a word in the
cell next to it.

Please help.

Thanks.

Marc
 
Jimmy,

And if you sort the table on the column with names, the duplicates will be
together. You can then sort the table again on whatever column it was
originally ordered on.

Earl Kiosterud
www.smokeylake.com
 
Back
Top