compare 2 lists and common ones display on the 3rd column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

elaine - 05 Jul 2006 18:26 GMT

Hi,

Is there a way to compare data in 2 columns, and display the same ones
that occur in both lists to a 3rd column?

Thanks.
Elaine.

Reply to this Message

somethinglikeant - 05 Jul 2006 18:38 GMT

Use a macro:-

Sub CompareAndPutinColumn3()
j = 1
For i = 1 To Application.WorksheetFunction.CountA(Columns(1))
If Application.WorksheetFunction.CountIf(Columns(2), Cells(i, 1)) >
0 Then
Cells(j, 3) = Cells(i, 1)
j = j + 1
End If
Next i
End Sub

somethinglikeant

> Hi,
>
[quoted text clipped - 3 lines]
> Thanks.
> Elaine.

Reply to this Message

elaine - 11 Jul 2006 15:48 GMT

thanks!!!

> Use a macro:-
>
[quoted text clipped - 18 lines]
> > Thanks.
> > Elaine.

Reply to this Message

elaine - 11 Jul 2006 15:48 GMT

thanks!!!

> Use a macro:-
>
[quoted text clipped - 18 lines]
> > Thanks.
> > Elaine.

Reply to this Message

Rate this thread: