Comparing data in 2 columns

Posted by Abbie on October 08, 2001 10:24 AM

I have two columns or GL Account Numbers, I'm looking for some kind of function that will look at the two numbers in each row and let me know if they are exactly the same. The purpose of this is to assure me that I have the same account numbers on the same row.

0-600-9395 0-600-9390 not same
0-700-9615 0-700-9610 not same
0-400-9405 0-400-9405 same
0-600-9405 0-600-9395 not same
0-600-9415 0-600-9410 not same
0-400-9410 0-400-9410 same
0-600-9410 0-600-9405 not same
0-300-9420 0-300-9420 same

Thanks as always for your help!
Abbie~~

Posted by Aladin Akyurek on October 08, 2001 10:52 AM

Abbie,

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

Aladin

========

Posted by Juan Pablo on October 08, 2001 11:20 AM

You could use
=A1=B1

to return TRUE when they are the "same" and FALSE when "not same"...

Juan Pablo

Posted by Aladin Akyurek on October 08, 2001 11:34 AM

Complied with Abbie wanted to see. (NT)

Posted by Juan Pablo on October 08, 2001 11:35 AM

I know, just trying to make formulas easier :-) (NT)

Posted by RichT on October 09, 2001 10:57 AM

If your columns are A1 thru C1,
try entering this in C3:
=if(A1=B1,"same","not same")
or more simply
=A1=B1
will get you a TRUE/FALSE result