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

any Excel pros here?

Discussion in 'BlackHat Lounge' started by firstnamelastname, Feb 21, 2017.

  1. firstnamelastname

    firstnamelastname Regular Member

    Joined:
    Jun 20, 2015
    Messages:
    203
    Likes Received:
    34
    I am going through different ahrefs reports and copy/pasting any backlinks that I like to investigate into an Excel sheet. When I copy/paste sometimes the backlink already exists in the excel sheet because I had already found it from another competitor's website, so I end up with a lot of duplicates.

    so for examples,

    Forbes.com
    Engadget.com
    Articlebase.com
    Forbes.com

    see? Forbes appears twice.

    Is it possible to set up excel so as soon as I paste the duplicate domain, excel somehow indicates that this entry already exists?
     
  2. uncutu

    uncutu Elite Member

    Joined:
    Aug 6, 2010
    Messages:
    1,638
    Likes Received:
    845
  3. goltara

    goltara Newbie

    Joined:
    Feb 21, 2017
    Messages:
    11
    Likes Received:
    3
    Gender:
    Male
    Hi, you can just google it! "don't paste duplicates in excel" and the first result is your solution. Regards!