By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,384 Members | 671 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,384 IT Pros & Developers. It's quick & easy.

NEED Urgent help from the group re: comparing 2 columns thru VBA

P: 1
Hi there,

I'm a newbie in vba programming and wld appreciate so much for any advice on how to program my daily task in the ofc.

In Excel, how to compare and match data of 2 columns that will return TRUE (means there's a match) or FALSE (if no match)
If TRUE, returns the same value on column B
if FALSE, column B will be blank (and vice versa)

EXAMPLE:

GROUP1
ana
gloria
sofia
grace
mona
jackie
eve

GROUP2
ana
gloria
grace
celine
jackie
flor
eve


RESULT:
Expand|Select|Wrap|Line Numbers
  1. GROUP1       COMPARISON    GROUP2
  2. ana            TRUE      ana
  3. gloria            TRUE      gloria
  4. sofia            FALSE    
  5. grace            TRUE      grace
  6. mona            FALSE    
  7.             FALSE      celine
  8. jackie            TRUE      jackie
  9.             FALSE      flor
  10. eve            TRUE      eve
Thank you so v much for your time....
Apr 27 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 5K+
P: 8,434
Does it definitely have to be done in VBA code? You could set up columns like that fairly simply in Excel without the use of a macro.
May 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.