Delete rows with multiple columns with 0 value
You could just use a formula.
=if(countif(c2:n2,0)=12,"X","")
So, if you have 0 in ALL columns between c and n, you will have an x.
Otherwise you'll have a blank.
then you filter by this column, select x and delete rows.
"Tasha" wrote:
On my spreadsheet, I want to delete rows that have 0 values in columns C
through N. If any of these columns have something other than 0, I need them
to stay. Can someone help me with a macro that would do this? I found a
post that would do this for 2 columns, but I couldn't figure out how to do it
for more than 2 columns.
|