Remove duplicate data from worksheet

Hi,

Is there a function which will remove all instances of duplicated data from a spreadsheet rather than just one instance of a duplication? I purposely create duplications by merging two lists so that I can remove those who are in list A from list B. At the moment I sort alphabetically and conditional format duplicates then manually delete both which is time consuming!

Thanks,

Claire

Good question, I am actually looking for the exact same thing. I have a master worksheet of emails and recently was given an opt-out email worksheet. I need to remove all those listed in the opt-out from the master and as you state, doing it manually is time consuming. I have attempted to play around with some macros but I am pretty new to them.

Originally Posted by martindwilson

check your list assuming its in col a starting a2 with in another colum =COUNTIF(A:A,A2)>1 drag down
filter by true
delete all the rows

So you are suggestion that you insert a col, say its col B. Then starting with b2 I put in =COUNTIF(A:A,A2)>1 and the fill down for the entire col. Once that is done I filter the col by true and delete all the trues?

Just had reason to run my de-dupe and this works a treat. Thanks very much you've saved me lots of time and boredom!

When I do this it seems to want to delete both the duplicate entry and the original 1