Deleting rows

  • Thread starter Thread starter ozhunter
  • Start date Start date
O

ozhunter

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
 
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
 
Back
Top