Hi I am trying to update values in an inventory sheet but if value has no change then i cannot create a formula to show the previous value. Any help would be appreciated. Hope this makes sense. thanks MC
cust1 has starting value of 100
cust2 has starting value of 200
Thanks
<tbody>
</tbody>
cust1 has starting value of 100
cust2 has starting value of 200
Thanks
date | details | type | customer | in | out | cust1 | cust2 |
21/08/19 | order | AAA | cust1 | 500 | 100 | 500 | 200 |
21/08/19 | order | AAA | cust1 | 100 | 50 | 550 | 200 |
21/08/19 | order | AAA | cust2 | 50 | 100 | 550 | 150 |
21/08/19 | order | AAA | cust1 | 100 | 200 | 450 | 150 |
<tbody>
</tbody>