I have a master Excel 2010 file of about 10,000 contact names and addresses (each contact on a row) and another Excel 2010 file of about 500 contact names which I need to delete from the master file. The rows in each file contain the same information (Email & Name).
Is there a way that I can use a formula or something to delete the 500 rows from the master list without doing it manually one-by-one?
Some kind of formula which says look for this contact in this file and delete?
I'm not an expert on Excel but maybe someone can help or come up with a solution!
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Enter Foreign and Special Characters
Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~
Use these codes in any Windows application! ... whether it is a Micr…