Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

MS Excel Help

Options
  • 02-11-2006 1:16pm
    #1
    Claasman
    Registered Users Posts: 630 ✭✭✭


    OK, im not sure if this is the right forum to post this,
    OK, i have 2 lists,one with 177 and another with 560,
    some of the values in the first list are in the second.
    i dont want to have to check each one individually:eek: :eek:
    i have tried...

    =if
    =vlookup

    i would appreciate any help:confused::confused: ,
    thanks in advance:)


Comments

  • Options
    #2
    Seth Brundle
    Moderators, Politics Moderators Posts: 39,812 Mod ✭✭✭✭Seth Brundle


    Looping through your first range run a COUNTIF function against the second range.

    http://techonthenet.com/excel/formulas/countif.php


  • Options
    #3
    Tom Dunne
    Registered Users Posts: 23,212 ✭✭✭✭Tom Dunne


    Vlookup should do it for you. I don't have Excel on this machine, but I would approach it like this:

    Col 1 Col 2 Col 3
    list 1 vlookup List 2
    : : :
    : : :

    So Col 2 would contain some sort of flag to say what is in Col1 is pesent in Col 3. The Vlookup range would include all of List 2 in Col 3.


Advertisement