Hello,

I have a problem. Big time! I am trying to do a comparison of two columns that contain email addresses. If the same email address appears in both column A and Column B. Then I want to Place a '1' or True in column C.

Any help I get on this will be greatly appreciated.

Ever

Music

Please post once to a forum...it will get read

You don't necessarily need to use vba to accomplish this. You can simply place a formula in the cells of column C as follows:

    

If the value of cell B1 matches the value of A1 exactly, the value displayed in C1 will be True. Otherwise, C1 will display False.

If you still want the vba code to perform the comparison between two cells, check the property example in the VBE help.


Good Luck,



Darrell L. Embrey

atternatively you could just place =EXACT(A1,B1)
and it will flag true (or FALSE) but will flag false even if the case of anything is different. and just copy down as far as you want

Do you mean that the EMAIL in column A might not be in the same ROW in COLUMN B?