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

Excel: show the row when either one of the columns is0
 

Assume that layout is at the top of the page, whatever formula is in the cell
A2 to make John's name appear, use this:

=IF(SUM(B2:M2)=0,"","John")

....and replace the "John" part with the existing function you're using.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"vicki" wrote:

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

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,

Excel: show the row when either one of the columns is0
 

Dear JB,

it works, many thanks for your help. : -)
--
vicki


"JBeaucaire" wrote:

Assume that layout is at the top of the page, whatever formula is in the cell
A2 to make John's name appear, use this:

=IF(SUM(B2:M2)=0,"","John")

...and replace the "John" part with the existing function you're using.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"vicki" wrote:

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

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,