Based on cheque number sum until it is zero

[manjuru]

Hi All,

I was trying to find a solution for my problem , where I have cheque numbers in column "A" and the amount in Column "B" . I am trying to knock off the values to zero based on the Cheque number. Could you please help with this problem? It would be a great help.

Cheque No	Amount	Knocking off
1001​	100​	X
1001​	-50​	X
1001​	-50​	X
1001​	-100​
1002​	50​	X
1001​	-100​
1002​	-25​	X
1002​	-25​	X
1003​	100​	X
1003​	-100​	X

 

[kvsrinivasamurthy]

Pl explain in detail what is required.