| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Cell Compares
I have an Excel spreadsheet with 30 rows in it. I need to write a
formula or macro that will compare the value of cell C1 to C2. If the value is the same then I need it to look at cells E1 and E2 to see if the value of either is ZZ. If the value is NOT ZZ then I need it compare cells C2 to C3 etc to the bottom of the worksheet. If the value is ZZ then I need it to delete rows 1 and 2. Can someone help with how to accomplish this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif compares to Countifs | Excel Worksheet Functions | |||
| Fix EXACT function so it always compares in the same row. | Excel Worksheet Functions | |||
| IF statement (non nested) that compares cell value against range | Excel Worksheet Functions | |||
| Function that compares dates | Excel Worksheet Functions | |||
| formula that compares different ranges | Excel Worksheet Functions | |||
Linear Mode
