Comparing two columns
Posted by Don on November 20, 2001 7:46 AM
What formula can I use to compare data in two columns to see if the data in column 2 is in column 1. If it is in column 1 I would like it to say true.
Thanks
Posted by Juan Pablo on November 20, 2001 7:49 AM
=IF(COUNTIF(A:A,B1),"True","") and drag down
Posted by Aladin Akyurek on November 20, 2001 7:51 AM
Lets say that you want compare A and B.
In C1 enter: =COUNTIF(A:A,B1)>0
or
=ISNUMBER(MATCH(B1,A:A,0))
Aladin
========
