| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: show the row when either one of the columns is0
Dear freinds:
I have the worksheet below: Name Jan Feb Mar Apr May Jun---Dec John 1 0 5 4 0 0 Mary 0 0 0 0 0 0 Peter 2 0 0 1 0 0 is it the report can be shown automaticall that: only to show the name when either from Jan to Dec the figure is0 since this worksheet data are the data referred from another worksheet, so I cannot just hide the row "Mary", as Mary may have/have not figures is 0 during Jul - Dec thanks in advance for all your help -- vicki |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Only show certain columns | Excel Worksheet Functions | |||
| Show all columns in Excel | Excel Discussion (Misc queries) | |||
| Excel should show Comment box even if adjacent columns are hidden | Excel Discussion (Misc queries) | |||
| How do I only show a range of columns/rows in Excel? | New Users to Excel | |||
| How do you print an Excel worksheet to show the rows and columns? | New Users to Excel | |||
Threaded Mode
