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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

MS Excel Help

  • 02-11-2006 12:16pm
    #1
    Claasman
    Registered Users, Registered Users 2 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

  • #2
    Seth Brundle
    Moderators, Politics Moderators Posts: 41,239 Mod ✭✭✭✭Seth Brundle


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

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


  • #3
    Tom Dunne
    Registered Users, Registered Users 2 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