Formula that compares data in adjoining cells

[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.

 

[Pete_UK]

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

 

[Guest]

Use

=A1=B1

in C1 and fill down.

 

[Guest]

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...