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!

Comparing data in two columns for matches
Display two columns in data validation list but return only one - Guide
Tmobile data check - Guide
Transfer data from one excel worksheet to another automatically - Guide
How to be offline in whatsapp when data is on - Guide
Hosted app data ✓ - Google Chrome Forum

1 response

Answer 1 / 1

rizvisa1
Jan 29, 2010 at 03:18 PM

=IF(A2=B2, "YES", "NO")

Similar discussions

Comparing columns and returning value

AMD data change update new data to DMI

Unlock safe folder without losing any data

Facebook says that my email doesn't match my facebook email

How To Fix Mint Mobile Data Not Working?

Similar discussions

Subscribe To Our Newsletter!