Subtract Cell gradually according to Range list

[Kazi Mohammd]

Hi,
I have a large "Land Owner Database" of excel where "Column B" is divided according to "Column A" and and Area in "Column C".
"Column F" stores the purchase AREA. Now "MY Necessity" is to find out the Remaining Value in "Column G" according to "Column B" range Data.
Hope you will Understand my question.

My data is look like this (image attachment) .

Thanks in Advanced

 

[fadee2]

base on your question, see if the below helps...

=IF(B2=B1,G1-C2,F2-C2)

 

[fadee2]

base on your question, see if the below helps...

=IF(B2=B1,G1-C2,F2-C2)

place the formula in column G and use the fill handle to drag it down.

 

[Kazi Mohammd]

place the formula in column G and use the fill handle to drag it down.

It works for this. Have to check my for large dataset. Thanks a lot.

 

[fadee2]

You are Welcome.