MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

========