Deleting BOTH duplicate entries

J

Julian

I have a massive list that contain certain numbers that i need to look up in
a database. I also have another list of numbers that have already been looked
up. Some of the numbers in the second list are also in the first list. Is
there a way to merge these two lists so that all the duplicates are removed?
And I don't mean just one of the duplicate entries, but both of them.
Thank you
 
G

Guest

-----Original Message-----
I have a massive list that contain certain numbers that i need to look up in
a database. I also have another list of numbers that have already been looked
up. Some of the numbers in the second list are also in the first list. Is
there a way to merge these two lists so that all the duplicates are removed?
And I don't mean just one of the duplicate entries, but both of them.
Thank you
.
I find duplicates in lists using IF and OR. Copy both
Click to expand...
lists onto a new worksheet one above the other. Then sort
them together so that all duplicates are next to each
other. Let's say they are in column A with a header in A1.
In B2 type the equation: IF(OR(A2=A1,A2=A3),"dup","")
Then copy it down next to the entire list. This will put
dup next to all the cells which have a duplicate. Then
highlight the dup column, right click copy then paste
special which allows you to copy values only. Copy
the "dup" equations on top of themselves, just values
only, then sort both columns by the column that has the
dups in it. This will bring every entry with a duplicate
to the top and you can do what you want with it then.
 
Top