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
     
    Eddng, Mar 18, 2014
    #1
    1. Advertisements

  2. Eddng

    Vabs Guest

    Hi

    You can do using count if function as follows,

    =countif(A1,$B$1:B1)


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

    HTH//Cheers

    On Tuesday, March 18, 2014 3:24:55 PM UTC+5:30, Eddng wrote:
    > Hey everyone, I'm having a problem working out an issue and I've tried
    >
    > using the duplicate tool but it doesn't seem to be working the way I
    >
    > want it to.
    >
    >
    >
    > I have two lists of websites. List A is a full list and list B is over
    >
    > 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 unique
    >
    > websites. So if there a website listed twice, it would delete them both
    >
    > and it would leave me full of the websites that I haven't checked
    >
    >
    >
    >
    >
    >
    >
    >
    >
    > --
    >
    > Eddng
     
    Vabs, Apr 18, 2014
    #2
    1. Advertisements

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.
Similar Threads
  1. seratne

    Need to duplicate rows

    seratne, Mar 1, 2004, in forum: Excel Beginners
    Replies:
    6
    Views:
    78
    David McRitchie
    Mar 2, 2004
  2. Oscar

    View Duplicate entries

    Oscar, Mar 6, 2004, in forum: Excel Beginners
    Replies:
    11
    Views:
    144
    Frank Kabel
    Apr 27, 2004
  3. Mark

    Marking or deleting duplicate entries

    Mark, Apr 5, 2004, in forum: Excel Beginners
    Replies:
    2
    Views:
    96
  4. katkat

    Highlight Duplicate Row

    katkat, May 3, 2004, in forum: Excel Beginners
    Replies:
    1
    Views:
    83
    David McRitchie
    May 3, 2004
  5. Sam Weber

    Duplicate row's formatting

    Sam Weber, Jun 3, 2004, in forum: Excel Beginners
    Replies:
    7
    Views:
    120
  6. sgrech

    Help Help Help!!

    sgrech, Jan 23, 2006, in forum: Excel Beginners
    Replies:
    7
    Views:
    113
    Cutter
    Jan 25, 2006
  7. kimmy

    help help help IF function

    kimmy, Nov 18, 2006, in forum: Excel Beginners
    Replies:
    3
    Views:
    142
    Rookie 1st class
    Nov 19, 2006
  8. Lanzers

    Excel text data in a cell HELP HELP HELP

    Lanzers, Sep 4, 2008, in forum: Excel Beginners
    Replies:
    1
    Views:
    98
    Gary Brown
    Sep 4, 2008
Loading...