Free Microsoft Office Help for all Applications! |
|
|
|  |
||||||||
| Worksheet Functions Post questions in this forum if they are related to using Microsoft Excel Worksheet Functions, e.g Forumale or built in functionality etc. |
|
Hey there! |
|
|
|
LinkBack | Thread Tools | Display Modes |
11th May 2009, 10:39 AM
|
|||
|
|||
Show in another cell only >0 from a range?
------ Register to get rid of these "In Post" ads! ------
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. 'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/worksheet-functions/95275-show-another-cell-only-0-range.html#post340705 Thank You Richard 
Did you find this post helpful?  |
|
| The Code Cage Advertisment | ||
| ||
|
To stop seeing these ads and get other benefits check This page! |
|
11th May 2009, 12:47 PM
|
|||
|
|||
|
Re: Show in another cell only >0 from a range?
------ Register to get rid of these "In Post" ads! ------
See attached file to see the solution ....
Did you find this post helpful? |
|
| The Code Cage Advertisment | ||
| ||
|
To stop seeing these ads and get other benefits check This page! |
|
| Bookmarks |
| Tags |
| >0, cell, range |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
The Code Cage Affilliates
|
Linear Mode
