Remove emails program

Assuming the your long list is in column A and the short list is in column M, insert a column next to the names (column B) and insert this formula in B2 and copy down the length of the data in Column A:

=COUNTIF($M$1:$M$200,A2) Note the $ in the formula. This stops the range of cells being checked from changing while the formula is being copied down the length of the data.

Once the above has been done, a number will appear beside each entry in column A that is in column M.

Now select all the data for your first list and sort on column B so that all the values greater than 0 will be either sorted to the top of the list or the bottom of the list. Select all the data with values in column B that are greater than 0 and delete.

Click to expand...