Delete all rows where qty = 0

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have a HUGE spreadsheet (60K lines). If column "E" = 0, then I want to delete the entire row. I've worked on this for a couple of days and can't find anything that works. Any help will be appreciated!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Why not filter on 0 for column E
and then delete all the visible rows with data
and then remove the filter