Matching information in two columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,
I have two columns of data, column A and Column B.
I want to check for all matches in columns A & B..how would I do this?

thanks in advance,
 
I just asked the same question, and here are two answers that I received:

The following compares two columns and checks if both cells on the same row
are an exact match.

Put this formula into a new column, and copy it down.

=IF(A1=B1,"same","Different")

The following checks the data in a cell in column one, and looks if there is
the same data in any cell in column two.

=SUMPRODUCT(--(A1=$b$1:$C$30))

copy these formulas down the column.

It worked for me, and hope it works for you!
 
Back
Top