Finding and deleting a small list of names from a really big list of names

**vitalstatistix** · 07-05-2011, 02:04 PM

Yes!

Thank you sooo much! I didn't even know about the sort and filter option, I just added the names to a new 'Custom Sort...' list and had them sorted to the top!

This is great! I didn't even have to touch VBA. :D

Thank you Kindly Charles!

**vitalstatistix** · 07-05-2011, 02:19 PM

Errr, nm I spoke too soon.

Custom lists only allow for 255 characters, and I can't create more than one list for one variable because it won't let me sort that way..

I'll make an example of the data and post it here today or tomorrow.

Sorry!
V

**vitalstatistix** · 07-06-2011, 12:01 PM

Ok, So say for example the first list, from A1:A99 is my list of 100,000 names.

The second list, A101:A117, represents the 600 names that I need to remove from the first list. I want to delete the entire row that the name appears in.

Is there a way to make the filter automatically do this? I don't really want to find and click off 600 names in a list of 100,000.

Thank You!

**Charles** · 07-06-2011, 01:34 PM

HI,

Thanks for the workbook, however you are showing all of the data in column "A". Is that the way your actual data is laid out. The List of names you want to compare is in column A, but where are the names you want too remove ? Are they in the same workbook? And too i'm looking at doing this via code.

**vitalstatistix** · 07-06-2011, 02:10 PM

The second list can be placed anywhere. It is an independent list of names I need to remove from the original list It might make more sense to place it in a different worksheet. If I placed it in a different column I wouldn't be able to delete the entire rows though.

Hopefully someone can help us out!

Cheers,
V