delete all text that match
 

I would like to compare a standard list of text to a second list that could
contain more than one of the same text. Then either delete the text that
compares on the second list or highlight it in some way.

Thanks in advance

Hi

check out
http://www.cpearson.com/excel/duplicat.htm

for lots of ideas

Cheers

JulieD



"e3grk" wrote in message
...
I would like to compare a standard list of text to a second list that could
contain more than one of the same text. Then either delete the text that
compares on the second list or highlight it in some way.

Thanks in advance