Remove ids from large list

TheProfessor2015

Junior Member
Joined
Sep 20, 2015
Messages
152
Reaction score
7
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

Untitled.png

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
 
Last edited:
I was trying a vlookup formula, however excel kept crashing because of the large list
 
Back
Top