1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Remove ids from large list

Discussion in 'FaceBook' started by TheProfessor2015, Dec 3, 2015.

  1. TheProfessor2015

    TheProfessor2015 Junior Member

    Joined:
    Sep 20, 2015
    Messages:
    144
    Likes Received:
    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.
     
  2. aparungao

    aparungao Junior Member

    Joined:
    Apr 2, 2011
    Messages:
    100
    Likes Received:
    7
    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.
     
  3. TheProfessor2015

    TheProfessor2015 Junior Member

    Joined:
    Sep 20, 2015
    Messages:
    144
    Likes Received:
    7
    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: Dec 3, 2015
  4. TheProfessor2015

    TheProfessor2015 Junior Member

    Joined:
    Sep 20, 2015
    Messages:
    144
    Likes Received:
    7
    I was trying a vlookup formula, however excel kept crashing because of the large list