View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
marycler marycler is offline
external usenet poster
 
Posts: 1
Default How to remove double data?

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!