| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting rows
I have a spreadsheet that has a large number of rows, some of which have data
in only one cell in that row (the sum of the cells above for example). I would like to be able to delete all rows that contain nothing or "" as the result of a formula. Can anyone help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Deleting rows
Suppose you have data from Col A to Col J and want to delete all rows which
do not have data.. In Cell K1 enter the below formula which will return TRUE if all cells in the row are blank or "" in the row. copy the formula down. Sort that column. Delete all rows with TRUE. =COUNTIF(A1:J1,"")=(COLUMN()-1) If this post helps click Yes --------------- Jacob Skaria "ozhunter" wrote: I have a spreadsheet that has a large number of rows, some of which have data in only one cell in that row (the sum of the cells above for example). I would like to be able to delete all rows that contain nothing or "" as the result of a formula. Can anyone help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for deleting rows and serialising the remaing rows | Links and Linking in Excel | |||
| Macro for deleting rows and serialising the remaing rows | Setting up and Configuration of Excel | |||
| Macro for deleting rows and serialising the remaing rows | Excel Worksheet Functions | |||
| Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
| deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
Linear Mode
