LinkBack URL
About LinkBacks
Hello guys,
I have two columns with agency IDs. I would like to know which IDs in column 1 does NOT appear in column 2. Column 1: 211 IDs and colums 2: 93 IDs. Please any help! Perhaps Vlookup?
Thank you MarvinId_test.xlsx
Hello guys,
I have two columns with agency IDs. I would like to know which IDs in column 1 does NOT appear in column 2. Column 1: 211 IDs and colums 2: 93 IDs. Please any help! Perhaps Vlookup?
Thank you MarvinId_test.xlsx
In c2
=COUNTIF(B:B,A2)>=1
Copy down till Row 212
FALSE represents that ID in column 1 is not in Column 2
Life's a spreadsheet, Excel!
Say thanks, Click *
Thank ACE. I greatly appreciate!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks