| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get the MAX value of adjoining columns then SUM range? | Excel Worksheet Functions | |||
| Excel formula for summing using figures from adjoining rows | Excel Worksheet Functions | |||
| 3 criteria must exist in adjoining cells then rtn val from 4th | Excel Discussion (Misc queries) | |||
| Search range of cells, find a value, output adjoining cell. How? | Excel Worksheet Functions | |||
| formula that compares different ranges | Excel Worksheet Functions | |||
Linear Mode
