delete from 1 list based on another list

[cherrynich]

I have a list(list1) that includes account numbers, on a different sheet I
have a another list(list2) that includes account numbers. I want to use
list2's account numbers as criteria to delete list1's account numbers so when
I combine the list there are no duplicates. I would just combine the lists
and delete duplicates but I need everything from list 2 and only want to
delete from list 1. I don't know of any easy way to do this. Please help.

 

[Norman Jones]

Hi Cherrynich,

See Chip Pearson's Duplicates page:

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

The page describes several techniques which may be of assistance.

See, for example, the section at the foot of the page entitled:

Extracting Values On One List And Not Another