hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,215
- Office Version
- 2010
- Platform
- Windows
- Mobile
Input Range C2:C8…ONLY 1 cell contains Non Zero value
Output in D2 as Non Zero Value from C2:C8
How to accomplish?
Thanks in advance
Sheet1
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>
Output in D2 as Non Zero Value from C2:C8
How to accomplish?
Thanks in advance
Sheet1
C | D | |
2 | 0 | 588 |
3 | 0 | |
4 | 0 | |
5 | 588 | |
6 | ||
7 | 0 | |
8 | 0 |
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>