Forum Discussion
How to delete rows that have a 0 in every column but not rows that have 1 column thats not 0
I have an excel sheet with 8000+ rows of data, there is 18 columns. each column represents a sample, each row is a different bacteria. so in each cell is the quantity of that bacteria (row) in t...
As variant you may add helper column with SUM(row) in each cell. Filter entire range on this column, select 0 only, select from top to down of filtered rows -> Delete entire sheet row.
These are the types of answers the world needs more of; beautifully simple and effective. This solved hours of struggle for me. Thanks SergeiBaklan
RKT_Scientist , you are welcome