Hide row if dollar amount is zero


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
 
B

Bob Phillips

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

Some and not others? What determines?
 
Ad

Advertisements

K

Karl Irvin

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.
 
B

Bob Phillips

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.
 
K

Karl Irvin

The autofilter doesn't work. I tried the advanced filter and it doesn't work
either.
 
Ad

Advertisements

D

Dave Peterson

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top