K Karl Irvin May 6, 2005 #1 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 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 May 6, 2005 #2 Simplest way - put a filter (Data>Filter>Autofilter) on the column and filter a zero value. Some and not others? What determines?
Simplest way - put a filter (Data>Filter>Autofilter) on the column and filter a zero value. Some and not others? What determines?
K Karl Irvin May 6, 2005 #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.
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 May 6, 2005 #4 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. Click to expand...
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. Click to expand...
K Karl Irvin May 6, 2005 #5 The autofilter doesn't work. I tried the advanced filter and it doesn't work either.
D Dave Peterson May 7, 2005 #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.)
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.)
