I have a range (R10:V14). Residing in the cells of this range will always be
one name and the rest zeros. The name may change and/or move to another cell
within this range. This is my question? How do I have, lets say cell E38 show
whatever appears in this range other than zero. In other words, only the name
that appears in the range will show in cell E38 ignoring all the zeros.

Thank You

Richard