Deleting rows

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find last column matching criteria 2
nth row or column counting 1
What is the "--" (double dash) in MS Excel formula? 2
Sorting and grouping data with varying number or rows 1
Selecting rows. 3
Row protection 1
hidden rows problem 7
Number of rows with a non blank cell 3

Top