Need help with Excel - how to cull one list, using another list?

[ksinclair]

I have a long list of domains; lets say that is column 1 in an excel sheet. This is a list of all my domains.

I have a smaller list of domains, lets say that is in column 2. the smaller list is a list of domains i have dropped. it is longer than i would like actually.

i want to run the 2nd list against the first; so that every domain in the 2nd list, is removed from the first.

how to do that in one operation? Is excel the best way?

Kevin

 

[Jack Gordon]

I have a custom Excel addin that will do this. It would require installing it into your Excel application. PM me if you are interested.

 

[INFORG]

You could use a lookup feature that compared each name in list 1 to list 2 and at least put an X next to the duplicates. Then you can resort and delete those lines. PM me your email and I can shoot you an example sheet if you like.

 

[foundrstack]

It's also possible to do this in PHP so if you don't find a solution feel free to send me a PM.