Duplicate Help

Discussion in 'Excel Beginners' started by Eddng, Mar 18, 2014.

  1. Eddng

    Eddng Guest

    Hey everyone, I'm having a problem working out an issue and I've trie
    using the duplicate tool but it doesn't seem to be working the way
    want it to.

    I have two lists of websites. List A is a full list and list B is ove
    60/70% of websites from List A that I have checked through.

    Now I want to put the two lists together and leave only the uniqu
    websites. So if there a website listed twice, it would delete them bot
    and it would leave me full of the websites that I haven't checke
    Eddng, Mar 18, 2014
    1. Advertisements

  2. Eddng

    Vabs Guest


    You can do using count if function as follows,


    where A1 contains 1st List of website & column B contains list 2 of your websites name.

    Vabs, Apr 18, 2014
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.