Mike

Visit Chip Pearson's site for much help on duplicates.

Finding, tagging, preventing and others.

http://www.cpearson.com/excel/topic.htm

Scroll down to Duplicates section.


Gord Dibben Excel MVP

On Sun, 4 Sep 2005 09:49:11 -0500, mlhynes
wrote:


Hi

I need some help on the following.

I have a column of text, linked to other worksheets, that is
continuously changing. I need to be alert if the same piece of text
appears in the column more than twice, e.g.

Tom
Tom
Jane
Mary
Mary
Tom

"ALERT"

Thanks
Mike