| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF cell=TRUE how can I delete that row in formula
I am using this code to test for near duplicate entries but can not auto
delete row that tests OK or TRUE =IF(MID(A2,1,5)=MID(A3,1,5),IF(MID(B2,1,8)=MID(B3, 1,8),"OK","NOT OK")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a formula to "go to" another cell if a condition is true? | Excel Discussion (Misc queries) | |||
| ISTEXT TRUE then copy formula from cell X | Excel Worksheet Functions | |||
| IF function...cell ref is a formula so True is retd when False sh | Excel Worksheet Functions | |||
| If a formula is too long then refer to the cell after a TRUE resul | Excel Programming | |||
| formula to return the value of a cell based on a looked up true reference | Excel Worksheet Functions | |||
Threaded Mode
