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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. seratne

    Need to duplicate rows

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

    View Duplicate entries

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

    Marking or deleting duplicate entries

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

    Highlight Duplicate Row

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

    Duplicate row's formatting

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

    Help Help Help!!

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

    help help help IF function

    kimmy, Nov 18, 2006, in forum: Excel Beginners
    Replies:
    3
    Views:
    130
    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:
    86
    Gary Brown
    Sep 4, 2008
Loading...