| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CAn IF compare two cells?
I would like to compare cell C3 to C2. If C3 is the same as C2 then mark it
as DUP else goto next line and repeat the action. Compare C4 to C3, etc. -- Is it the times or the Zeitgiest? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CAn IF compare two cells?
Hi,
Out this in D3 and drag down as far as required =IF(C3=C2,"DUP","") Mike "KevinS" wrote: I would like to compare cell C3 to C2. If C3 is the same as C2 then mark it as DUP else goto next line and repeat the action. Compare C4 to C3, etc. -- Is it the times or the Zeitgiest? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare 400 cells to one | Excel Worksheet Functions | |||
| Compare 2 cells for a value | Excel Discussion (Misc queries) | |||
| How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
| Compare cells | Excel Worksheet Functions | |||
| Compare two cells from reference cells | Excel Worksheet Functions | |||
Linear Mode
