hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,213
- Office Version
- 2010
- Platform
- Windows
- Mobile
Input Range:C2:M2
By default C2:M2 is either 0 or “” (null)
Else positive integer
Formula required in A2: HIGHEST value from C2:M2
If ALL values in C2:M2=0, negative (less than 0) or null, A2 should be “” (null)
How to accomplish?
Thanks very much for your time given & help in advance.
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"></colgroup><tbody>
</tbody>
By default C2:M2 is either 0 or “” (null)
Else positive integer
Formula required in A2: HIGHEST value from C2:M2
If ALL values in C2:M2=0, negative (less than 0) or null, A2 should be “” (null)
How to accomplish?
Thanks very much for your time given & help in advance.
A | B | C | D | E | F | G | H | I | J | K | L | M | |
2 | 100 | 12 | 1 | 25 | 11 | 2 | 15 | 18 | 17 | 18 | 100 | 7 |
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"></colgroup><tbody>
</tbody>