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.


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