delete all text that match

[e3grk]

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

[JulieD]

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" <e3grk@discussions.microsoft.com> wrote in message
news:5A036337-0B63-4B9B-9532-ACBF222F0A5B@microsoft.com...
>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