Hello All,
I am trying to get an excel formula to get result in row#2 based on the value data in row#1.
The first value in row#1 is always equal to same value which is 5, following the next number, which is 16, the result must be 16-5=11, and scanning through the next value is 20 subtract the last lookup value on same row is 16, which should be 20-16=4. I hope I am getting my point clear.
<tbody>
</tbody>
Thanks much,
*BDT
I am trying to get an excel formula to get result in row#2 based on the value data in row#1.
The first value in row#1 is always equal to same value which is 5, following the next number, which is 16, the result must be 16-5=11, and scanning through the next value is 20 subtract the last lookup value on same row is 16, which should be 20-16=4. I hope I am getting my point clear.
A | B | C | D | E | F | G | H | I | J | K | L | |
1 | 5 | 16 | 20 | 45 | ||||||||
2 | 5 | 11 | 4 | 25 | ||||||||
3 |
<tbody>
</tbody>
Thanks much,
*BDT