Need to remove names on one excel file from a larger list

[jacobdaneman]

I have two excel workbooks, one large mailing list, and a smaller one. In days past, someone combined the two, but not by consolidating, but actually typed in the info. Now, the people on the smaller one need to be removed from the larger one. How do I do this?

 

[jdee]

You could do a lookup formula on the larger list, looking up the name on the smaller list. You could then filter the lookup list by looking for names that do not =N/A. This would give you all the names that would be eliminated from the first list and could be deleted. After deleting from the first list you could then remove the blank lines.