Hello
I need a formula to find a cell value with respect to another cell, like
<tbody>
</tbody>I need output 10/5 for row 2 as 45 is last non-empty cell
& 11/5 for row 3 as 15 is last non-empty cell.
Thanks
I need a formula to find a cell value with respect to another cell, like
A | B | C | D | E | F | |
1 | 6/5 | 7/5 | 8/5 | 9/5 | 10/5 | 11/5 |
2 | 14 | 33 | 45 | |||
3 | 10 | 50 | 87 | 15 |
<tbody>
</tbody>
& 11/5 for row 3 as 15 is last non-empty cell.
Thanks