delete from 1 list based on another list
 

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.

delete from 1 list based on another list
 

Hi Cherrynich,

See Chip Pearson's Duplicates page:

http://www.cpearson.com/excel/duplic...tingDuplicates

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


---
Regards,
Norman



"cherrynich" wrote in message
...
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.