Hi
with a macro see Cpearson web it has other options as well including the macro

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

"marycler" wrote:

Hello,

I have this list, lets call it A, that contains 3 columns. I have another
list, B, that as the same number of columns. List A contains all the data of
list B.

In list A, I would like to be able to remove all the data that can be found
in list B. Is there a specific function? I tried working with the Advanced
filter where I chose to work with Unique records only but it doesn't quite
work as list A remains unchanged.

Can you offer some help?

Thanks!