Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter a negative dollar amount? | Excel Discussion (Misc queries) | |||
need help with Index, Match and Countif in the same complicated formula | Excel Discussion (Misc queries) | |||
To find a combination of numbers that equal a set amount? | Excel Discussion (Misc queries) | |||
Loan Amortization Template - Amount of Final Payment | Excel Discussion (Misc queries) | |||
finding highest dollar amount | Excel Worksheet Functions |