Hide row if dollar amount is zero

  • Thread starter Thread starter Karl Irvin
  • Start date Start date
K

Karl Irvin

How do you hide a row if an amount on the row is zero?

Can this be done for some rows and not others?

Thanks
 
Simplest way - put a filter (Data>Filter>Autofilter) on the column and
filter a zero value.

Some and not others? What determines?
 
Its for a financial statement

Current Assets
Cash 1
A/R 2
Inv
Total 3

Fixed Assets
Cars 4

I need to drop just the Inv row.
 
So does the filter work?

--
HTH

Bob Phillips

Karl Irvin said:
Its for a financial statement

Current Assets
Cash 1
A/R 2
Inv
Total 3

Fixed Assets
Cars 4

I need to drop just the Inv row.
 
The autofilter doesn't work. I tried the advanced filter and it doesn't work
either.
 
How about using a helper column of cells.

Then put something like:

=a2&b2
and drag down your range.
(column A contains the description (INV) and column B contains the value (blank
or 0).

Then custom filter on that column:
does not equal: inv
and
does not equal: inv0

(not sure what to do with blanks next to INV.)
 
Back
Top