Hide row if dollar amount is zero
 

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 (DataFilterAutofilter) on the column and
filter a zero value.

Some and not others? What determines?


--
HTH

Bob Phillips

"Karl Irvin" wrote in message
...
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

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.

"Bob Phillips" wrote in message
...
Simplest way - put a filter (DataFilterAutofilter) on the column and
filter a zero value.

Some and not others? What determines?


--
HTH

Bob Phillips

"Karl Irvin" wrote in message
...
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

So does the filter work?

--
HTH

Bob Phillips

"Karl Irvin" wrote in message
...
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.

"Bob Phillips" wrote in message
...
Simplest way - put a filter (DataFilterAutofilter) on the column and
filter a zero value.

Some and not others? What determines?


--
HTH

Bob Phillips

"Karl Irvin" wrote in message
...
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

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

--
Karl Irvin
www.q2q.us
"Bob Phillips" wrote in message
...
So does the filter work?

--
HTH

Bob Phillips

"Karl Irvin" wrote in message
...
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.

"Bob Phillips" wrote in message
...
Simplest way - put a filter (DataFilterAutofilter) on the column and
filter a zero value.

Some and not others? What determines?


--
HTH

Bob Phillips

"Karl Irvin" wrote in message
...
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

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

Karl Irvin wrote:

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

--
Karl Irvin
www.q2q.us
"Bob Phillips" wrote in message
...
So does the filter work?

--
HTH

Bob Phillips

"Karl Irvin" wrote in message
...
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.

"Bob Phillips" wrote in message
...
Simplest way - put a filter (DataFilterAutofilter) on the column and
filter a zero value.

Some and not others? What determines?


--
HTH

Bob Phillips

"Karl Irvin" wrote in message
...
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









--

Dave Peterson