Formula that compares data in adjoining cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I need a formula that compares (i.e. look for an exact match), data in
cell B1 to data in cell A1, and data in cell B2 to cell A2 etc... and return
a True or Yes result if the data matches, or False or No result if the data
doesn't match, in the corresponding cell of cloumn C.
 
Try this in C1:

=A1=B1

then copy down by double-clicking the fill handle (the small black
square in the bottom right corner of the cursor).

Hope this helps.

Pete
 
Thanx Peter and Wigi, the formula works perfectly. I even adapted
"conditional formatting" to have the cells with "FALSE" indicated in red.

Thanks again for your assistance...
 
Back
Top