Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete rows in which the result of the formula is " "
This is my formula in each row in my table has an if/then statement to pick
up corresponding values from the same rows in other worksheets if the value in the subsequent worksheet is greater than 0, otherwise leave blank. Now I want to be able to delete the rows with a "" value. I have tried to write a Do/Until loop to look at each row in the table, but I cannot figure out how to word the statement telling it what to do when it encounters the "" values. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Result is "V6", need Excel to use cell "V6", not the resul | Excel Worksheet Functions | |||
delete rows if cell in row contains "a" or "o" or empty | Excel Programming | |||
Look for cell containing "Initial" then if the next cell after equals "Final" then delete both rows. | Excel Programming | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming | |||
Search "Total" in all worksheets and delete rows containing "Total" | Excel Programming |