View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vicki Vicki is offline
external usenet poster
 
Posts: 70
Default 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