Previous Topic Next Topic

Comparing data in two columns for matches

Closed
Quick hands - Jan 26, 2010 at 11:17 AM
 rizvisa1 - Jan 29, 2010 at 03:18 PM
Hello,

I am lookin for a formula that can compare two columns of data to see if they match. For example:

A B C
1 3 NO
5 5 YES
6 1 NO

Your help is greatly appreciated. Thanks!

1 response

Answer 1 / 1
rizvisa1
Jan 29, 2010 at 03:18 PM
=IF(A2=B2, "YES", "NO")
1

Similar discussions

Comparing columns and returning value
ll -
kittu -

35 responses
Extract identical cells of 2 columns (excel)
Little bit lost -
keliza -

3 responses
Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
Facebook says that my email doesn't match my facebook email
@@@@@@@@@@@ -
Ambucias -

1 response
Spreadsheet data
ankharm -
TrowaD -

9 responses