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 |
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 |
All times are GMT +1. The time now is 12:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com