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


--
mlhynes
------------------------------------------------------------------------
mlhynes's Profile: http://www.excelforum.com/member.php...o&userid=12959
View this thread: http://www.excelforum.com/showthread...hreadid=401787