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.

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.

Any help I get on this will be greatly appreciated.
Ever
:(

Music

Ever

You need to sort each column individually and then the sort function will work, I tested this in Excel. After you have sorted the columns, then use an IF statement to compare the two columns. E.g formula would be =IF(A1=B1,1,"").

If this does not work another alternative would be to use the following formula: =IF(COUNTIF(A1:A3,B1),1,"")and then you do not need to use the sort function.

Hope these suggestions helps
Regards
Llewellyn

Maybe you can use this one:

Sub RowNoOfDublet()
Dim a, b, c As Integer
a = 1
b = 1

Application.ScreenUpdating = False
For b = 1 To 50 '(50 is the No of rows in col B)
    For a = 1 To 50 '(50 is the No of rows in col A)
        Cells(a, 1).Select
        If Cells(a, 1).Value = Cells(b, 2).Value Then
            Cells(b, 3).Value = Cells(a, 1).row
        End If
    Next a
Next b
Application.ScreenUpdating = True

End Sub

In col C it states in which row in A the dublet is found. If you want it only to state a 'True' then replace:

            Cells(b, 3).Value = Cells(a, 1).row
with
            Cells(b, 3).Value = "True"