• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to compare and contrast data from two columns?

Prinz Jaymes

Prinz Jaymes

Member
Hi guys
Is there a VBA code that can match names or complex values between two columns?
Or even better, sort out the ones that do not match at all?
 
Hi Narayan
Prgram List Client Program Used
FNP_PROJECT_DEAN New York PNG grp PJT_SCHOLARSHIP_NEW
PJT_END_KDS MTN Global PJT_SCHOLARSHIP_BNK
PJT_SCHOLARSHIP_NEW Proctor & Gamble FNP_PROJECT_DEAN
FNP_MNY_NEW Samsung R&D BRN_PJT_KNP or FNP_PROJECT_DEAN
PJT_SCHOLARSHIP_BNK New York PNG grp FNP_PROJECT_DEAN
The "Program List" contains the programs to be applied, however, "Programs Used" includes new ones that were not included in "Program List" and should. Is there a VBA code, that can "Reference" or "Match" the values in , say A:A to the new ones in B2:B
For instance,
FNP_PROJECT_DEAN tells me
B3
B4
B5
Note, in B5, FNP_PROJECT_DEAN is part of a list with values SEPARATED by "or"
Or is there a code that can pinpoint
SIMILARITIES between the two (or more) columns
Whats in Column A and not in B?
What s in Column B and not in C? Usually, I ask Excel to sort out all the duplicated and Unique values. Just need a code where I can sort out the Programs used faster and create some kind of database.
Thanks
 
You must log in or register to reply here.
Back
Top