Previous Topic Next Topic

Delete all rows where qty = 0

Closed
Vivian - Jun 25, 2010 at 08:56 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 25, 2010 at 03:50 PM
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!

Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 25, 2010 at 03:50 PM
Why not filter on 0 for column E
and then delete all the visible rows with data
and then remove the filter
0