| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show in another cell only 0 from a range?
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show in another cell only 0 from a range?
See attached file to see the solution .... +-------------------------------------------------------------------+ |Filename: Richard.xls | |Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=136| +-------------------------------------------------------------------+ -- mubashir aziz ------------------------------------------------------------------------ mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=95275 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show a filter of a range | Excel Discussion (Misc queries) | |||
| Show Data In Range not appearing in Separate Range | Excel Discussion (Misc queries) | |||
| Show field or range name in a cell | Excel Discussion (Misc queries) | |||
| how do I show a value = a value in a range (A1 = any(b1:b35)? | Excel Worksheet Functions | |||
| Formatting to show/not show "DUE" and "RECEIVED" in cell | New Users to Excel | |||
Linear Mode
