How to remove items in one list from another list in excel?

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.

If I have understand you, You can use countif function if the data are identical in both column

If the largest column is A and the smallest is in Range D1:D100 then you can type the formula like this in column B:

=COUNTIF(D1:D100,A2)

I have assumed row 1 is header and that you are in cell B2

drag and drop till the end of the column A

If the data is found in the range it should display a value greater than 0.

Then you filter on the value greater then 0 and delete the items (use the del or delete button on the keyboard)

If necessary you need to sort your data again

Recommended create a backup of your file in case of