substraction for subsequent row on basis of duplicate records

[sanjuss2]

Hi sir
Please give me solution on the issue i am facing now. actually i have 1 sheet with 5 columns as follows.
--- A ------- B -------------C ---------- D --------- E
1 ---A/c no.---bal 310313-----bal 310314---addition----Release
2----121 -----1280 ------------ 0 ---------- 1200 ------ 0
3----123----- 3500------------- 0 ---------- 900-------- 0
4 ----123----- 0 -------------2600 ---------- 0 --------- 0
5 ----129----- 0 -------------3900 -----------0---------- 3900
6 ----130----- 4800----------- 0 -------------0---------- 0
7 ----130------ 0------------- 6200-----------0---------- 1400
8 ----136------ 900----------- 0 -------------900--------- 0

in above data I need to calculate amount as above means for duplicate records it must be calculate with 2 rows
Thanks in advance


awaiting for reply

 

[sanjuss2]

[h=2]

substraction for subsequent row on basis of duplicate records[/h]

Hi sir
Please give me solution on the issue i am facing now. actually i have 1 sheet with 5 columns as follows.
--- A ------- B -------------C ---------- D --------- E
1 ---A/c no.---bal 310313-----bal 310314---addition----Release
2----121 -----1280 ------------ 0 ---------- 1200 ------ 0
3----123----- 3500------------- 0 ---------- 900-------- 0
4 ----123----- 0 -------------2600 ---------- 0 --------- 0
5 ----129----- 0 -------------3900 -----------0---------- 3900
6 ----130----- 4800----------- 0 -------------0---------- 0
7 ----130------ 0------------- 6200-----------0---------- 1400
8 ----136------ 900----------- 0 -------------900--------- 0

in above data I need to calculate amount as above means for duplicate records it must be calculate with 2 rows
in row E & F i need answers as calculated in sheet
Thanks in advance


awaiting for reply
​