MikeWeaver
New Member
- Joined
- Jul 23, 2014
- Messages
- 26
I have a range similar to the table below, I would like to find using a formula the first and last nonzero value in the range. I would assume this should be done in two formulas, one to find the first nonzero value, and one to find the last.
<tbody>
</tbody>
In this example I would like the formulas to return 2 (position of first nonzero value) and 5 (position of last nonzero value).
Thank you for any help!
0 | 12 | 15 | 0 | 8 | 0 | 0 |
<tbody>
</tbody>
In this example I would like the formulas to return 2 (position of first nonzero value) and 5 (position of last nonzero value).
Thank you for any help!