Remove ids from large list

Hi All

Is there a way I can remove a list of ids from an excel file?

E.g. I have 100k list and I want to remove a specific 20k ids from the list.

An image would help. You could screenshot your excel file and put notes on what things you want to be removed. I might be able to help.

Let



Using above as an example ( I want to remove the data from column C from column A)

As the data in C is included in Column A

Basically ids I have added as friends from column C are included in column A, which I want to remove to avoid adding the same ids twice

I could sort the data by order and go down through the list and remove these ids manually , but with 20k ids to delete, it would take too long

I was trying a vlookup formula, however excel kept crashing because of the large list