Formula that compares data in adjoining cells
 

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.

Formula that compares data in adjoining cells
 

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

On Jul 10, 10:20 pm, Irv wrote:
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.

Formula that compares data in adjoining cells
 

Use

=A1=B1

in C1 and fill down.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Irv" wrote:

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.

Formula that compares data in adjoining cells
 

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

"Wigi" wrote:

Use

=A1=B1

in C1 and fill down.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Irv" wrote:

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.