| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do you delete blank rows in a spreadsheet using an "if" funct
what syntax is correct in the false part of an "if" statement to delete a
blank row...eg =if( a1= "Tom", B1,{ what goes here to delete the row so as blank rows are not returned} |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I delete rows from Pivot Tables in Excel 2000 as in 97 | Excel Discussion (Misc queries) | |||
| delete repeating rows | Excel Worksheet Functions | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| Blank Rows | Excel Discussion (Misc queries) | |||
| Data Filter - Not all rows in spreadsheet will display in Autofilt | Excel Worksheet Functions | |||
Threaded Mode
