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

[Former Member]

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:

Column1 : GROUP1

Column2 : GROUP2

GROUP1 GROUP2

ana ana

gloria gloria

sofia grace

grace celine

mona jackie

jackie flor

eve eve

RESULT:

COLUMN1: GROUP2

COLUMN2: COMPARISON

COLUMN3: GROUP2

GROUP1 COMPARISON GROUP2

ana TRUE ana

gloria TRUE gloria

sofia FALSE

grace TRUE grace

mona FALSE

FALSE celine

jackie TRUE jackie

FALSE flor

eve TRUE eve

Thank you so v much for your time....

[Former Member]

Use the function "match"

Regards.

[Former Member]

Myles, the comparison in excel is pretty simple..

See below

group1 group2 Result

ana ana true

gloria gloria true

sofia grace false

grace celine false

mona jackie false

jackie flor false

eve eva false

In the Result Column have a formula set up and copy the formula for the entire column to be compared :eg To compare B30 and C30 => =IF(B30=C30,"true","false")

HTH