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:(

Music

Try this
I assume row 1 is your header row so I'll move to row two.
Put this formula into C2
=Iif("A2"="B2","true","false")

This will return true if a2=b2, otherwise it will return false

Let me know if this helps

John

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 Cells Property Example in the VBE help.


Good Luck,



Darrell L. Embrey

These are all really good suggestions. However, I don't know where Column A will be equal to Column B. The two like emails may not occur in the same row. They may occur (for example) in cell A2 and Cell B54. I've tried to sort the columns but that doesn't do it.

Thanks

Music

You will need to use vb and do a comparison loop... while not overly difficult this does require knowledge of vb...what is your ultimate goal...perhaps access is a better application to do this in

John

you need to try some form of vlookup eg in col C. Set up a range to define the Column A data (or leave it as cell refs, up to you really). You need the false ion trhere, otherwise it comes up with 'close' matches, not exact.

HTH



There are two secrets to success in this world:
1. Never tell everything you know

You Guys,

I figured it out. Thank you so much.
Here is the solution.
And Here it is for anyone who cares.

=MAX(COUNTIF(A:A,B:B))

Elegant, yet effective.

Music