Return a value based on duplicate names

[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

 

[Bob Phillips]

Conditional formatting with a formula of

=COUNTIF($A$1:A1,A1)>1

 

[Earl Kiosterud]

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