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

Excel Help

Discussion in 'Black Hat SEO' started by switch_2012, Mar 19, 2013.

  1. switch_2012

    switch_2012 Power Member

    Joined:
    Feb 28, 2010
    Messages:
    504
    Likes Received:
    228
    Occupation:
    IM
    Location:
    UK
    Hi Guys,

    I need help with excel - i have two excel (2010) files (A, B),

    I need file B compared with file A - Any records in file B, thats also in file A needs to be removed from file B

    Anyone can help me with this? each file has about 2000 records.

    Many thanks,
     
  2. ija61

    ija61 Senior Member

    Joined:
    Mar 2, 2011
    Messages:
    960
    Likes Received:
    634
    Gender:
    Male
    Occupation:
    The first SEO economist:)
    Location:
    Romania
    Home Page:
    Use VlookUP function and where you get duplicate place "1" in a cell then sort and remove the row that have "1" on a certain column.

    Or send me the files and I will do it for you.

    P.S. A quick search on G could deliver the answer.
     
    • Thanks Thanks x 1
  3. switch_2012

    switch_2012 Power Member

    Joined:
    Feb 28, 2010
    Messages:
    504
    Likes Received:
    228
    Occupation:
    IM
    Location:
    UK
    ija61 - thank you for the reply mate - found a way to to do it, merge two files into a one then filter it to show unique then copy the records.

    Many thanks