Hello,
I have a tricky problem.
In the below, if there is not a 1 in the first column I want to return a 0. If there is a 1 in the first column I want to return the last number BEFORE the blank cell:
<tbody>
</tbody>
The numbers in BOLD are what I want returned at the end of each row.
Any help appreciated!
Thanks
I have a tricky problem.
In the below, if there is not a 1 in the first column I want to return a 0. If there is a 1 in the first column I want to return the last number BEFORE the blank cell:
1 | 2 | 3 | 4 | 5 | 5 |
1 | 2 | 3 | 4 | 4 | |
1 | 2 | 3 | 4 | 5 | 5 |
1 | 2 | 4 | 5 | 2 | |
2 | 3 | 0 | |||
2 | 3 | 4 | 5 | 0 | |
1 | 2 | 4 | 5 | 2 | |
1 | 2 | 3 | 5 | 3 | |
2 | 3 | 4 | 0 |
<tbody>
</tbody>
The numbers in BOLD are what I want returned at the end of each row.
Any help appreciated!
Thanks