Show in another cell only >0 from a range?

R

RJJ

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show value from one cell in another cell if today falls between a date range 5
How do I have a cell value define a dynamic named range? 15
Countif and values greater than zero for a named range 1
Dynamic Named Ranges 3
a data validation list that contains a list of named ranges - not alist from a named range 1
copy cells daily and automatically 3
Array with many cells from a row but not in order or together 11
Count time formatted data within range 1

Top