1

I need to delete every row in Excel that does not contain a "blank" value in one of its six columns.

I tried sorting each column, but there's 100k+ rows and that method really only works if I'm trying to sort by one column at a time.

1 Answer 1

2

You need to insert a helper column, where you check number of blank cells.

For example, if you need to check columns A - F, and G is an empty column, then enter in G1:
=COUNTA(A1:F1)
Now you have just to sort by column G, and delete rows with 0.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .