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.