Hi,
I wanted to return the last two non-zero values in a column. So, if I have
1
2
3
4
5
0
I want a formula to return 5 and another formula to return 4. Would like to avoid array formulas if possible.
Thanks!
I wanted to return the last two non-zero values in a column. So, if I have
1
2
3
4
5
0
I want a formula to return 5 and another formula to return 4. Would like to avoid array formulas if possible.
Thanks!
Last edited: