delete all text that match
 

I would like to compare a standard text list to a second text list. The
second list might have more than one of the same text. If any text rows of
the second list matches the standard list, the text of the second list would
either be deleted or highlighted in some way.

Thanks in advanced

hi

you have one reply to your question in microsoft.public.excel.misc

just for future reference it isn't necessary to post to more than one group
as most of the responders here read a number of groups and all it does is
fragment your answers and can annoy people who might spend time working on
an answer to a question only to discover that someone else answered in
another group.

Cheers
JulieD

"e3grk" wrote in message
...
I would like to compare a standard text list to a second text list. The
second list might have more than one of the same text. If any text rows
of
the second list matches the standard list, the text of the second list
would
either be deleted or highlighted in some way.

Thanks in advanced