Take value of first cell then subtract that from every cell for different materials

[Kulo5856]

In this image i need to get the stock will reduce from the remaining stock value 28 then ( 28 - 5)= 23, (23-3)= 20, like this for various materials
Exact take value of first cell then subtract that from every cell and also i have to apply this formula for all materials.
Please help

 

[GraH]

So for each product the first remaining Stock is the starting point?
Maybe [L1]=IF(COUNTIF($C$2:$C2,C2)=1,I2,I2-SUMIF($C$2:$C2,C2,$G$2:$G2))

 

[Kulo5856]

Actually i need to maintain the stock ledger which be showing the reducing balance stock if i filter the part number.

like this is exactly working for a single part number but im unable to apply for all part.

 

[Kulo5856]

For this stock ledger (IN + OUTSTANDING BALANCE - OUT ) = STOCK, from that stock to reduce OUT quantity + if any material IN.
For that need to apply formula for all part numbers

 

[Kulo5856]

So for each product the first remaining Stock is the starting point?
Maybe [L1]=IF(COUNTIF($C$2:$C2,C2)=1,I2,I2-SUMIF($C$2:$C2,C2,$G$2:$G2))

Kindly give best answer for my stock ledger
(IN + OUTSTANDING BALANCE - OUT ) = STOCK, from that stock to reduce OUT quantity + if any material IN.
For that need to apply formula for all part numbers

Now i get stock of this part number
From that opening stock to reduce remaining out balance

 

[GraH]

Hi, would you be able to provide some sample data using the XL2BB add-on please? Makes it more easier for us to help you (as we can't be expected to be typing in the data based on a screenshot to test our provided solution).

 

[Kulo5856]

Hi, would you be able to provide some sample data using the XL2BB add-on please? Makes it more easier for us to help you (as we can't be expected to be typing in the data based on a screenshot to test our provided solution).

Sample Stock Ledger Copy.xlsx
	A	B	C	D	E	F	G
1	###	Posting Date	Part No	Description	OB Qty	UOM	Count
2	1	01/04/2020	119-4151	Screw Special (57-4910)	10	Nos	28
3	2	01/04/2020	93-4264	Bedknife-Low Cut.	50	Nos	56
4	3	01/04/2020	92-9218	V belt	5	Nos	19
5
OB

Cell Formulas
Range	Formula
G2:G4	G2	=SUM(INDEX(E:E+'GRN SRN'!I:I-OUTWARD!G:G,MATCH(OUTWARD!C:C,'GRN SRN'!C:C,0),))
D2:D5	D2	=IFERROR(VLOOKUP(C:C,Dump!B:C,2,0),"")

Cells with Data Validation
Cell	Allow	Criteria
C2:C5	List	=Dump!$B$2:$B$600

Sample Stock Ledger Copy.xlsx
	A	B	C	D	E		G	H	I	J	K
1	###	Posting Date	Part No	Description	Customer / Vendor Name		Out Qty	UOM	Remaining Stock	Serial No	Remarks
2	1	02/05/2020	119-4151	Screw Special (57-4910)	XXXXX		2	Nos	28
3	2	04/05/2020	93-4264	Bedknife-Low Cut.	XXXXX		3	Nos	56
4	3	04/05/2020	92-9218	V belt	XXXXX		1	Nos	19
5	4	02/05/2020	119-4151	Screw Special (57-4910)	XXXXX		5	Nos	28
6	5	04/05/2020	93-4264	Bedknife-Low Cut.	XXXXX		3	Nos	56
7	6	02/05/2020	119-4151	Screw Special (57-4910)	XXXXX		3	Nos	28
8	7	04/05/2020	93-4264	Bedknife-Low Cut.	XXXXX		3	Nos	56
9	8	02/05/2020	119-4151	Screw Special (57-4910)	XXXXX		1	Nos	28
10	9	04/05/2020	93-4264	Bedknife-Low Cut.	XXXXX		3	Nos	56
11	10	04/05/2020	92-9218	V belt	XXXXX		1	Nos	19
OUTWARD

Cell Formulas
Range	Formula
D2:D11	D2	=IFERROR(VLOOKUP(C:C,Dump!B:C,2,0),"")
I2:I11	I2	=INDEX(OB!G:G,MATCH(OUTWARD!C:C,OB!C:C,0),)

Cells with Data Validation
Cell	Allow	Criteria
C2:C11	List	=Dump!$B$2:$B$600

Sample Stock Ledger Copy.xlsx
	A	B	C	D	E	F	G	H	I	J
1	###	Posting Date	Part No	Description	Sender / Supplier Name	Document No	GRN No	SRN No	In Qty	UOM
2	1	25/04/2020	119-4151	Screw Special (57-4910)	XXXXXXX	XXXX	XXX		20	Nos
3	2	25/04/2020	93-4264	Bedknife-Low Cut.	XXXXXXX	XXXX	XXX		9	Nos
4	3	25/04/2020	92-9218	V belt	XXXXXXX	XXXX	XXX		15	Nos
5	4	03/05/2020	93-4264	Bedknife-Low Cut.	XXXXXXX	XXXX		XXX	1	Nos
6	5	25/04/2020	93-4264	Bedknife-Low Cut.	XXXXXXX	XXXX	XXX		9	Nos
7	6	25/04/2020	92-9218	V belt	XXXXXXX	XXXX	XXX		15	Nos
8	7	03/05/2020	93-4264	Bedknife-Low Cut.	XXXXXXX	XXXX		XXX	1	Nos
9	8	25/04/2020	93-4264	Bedknife-Low Cut.	XXXXXXX	XXXX	XXX		9	Nos
10	9	25/04/2020	93-4264	Bedknife-Low Cut.	XXXXXXX	XXXX	XXX		9	Nos
11	10	25/04/2020	92-9218	V belt	XXXXXXX	XXXX	XXX		15	Nos
12	11	03/05/2020	93-4264	Bedknife-Low Cut.	XXXXXXX	XXXX		XXX	1	Nos
GRN SRN

Cell Formulas
Range	Formula
D2:D12	D2	=IFERROR(VLOOKUP(C:C,Dump!B:C,2,0),"")

Cells with Data Validation
Cell	Allow	Criteria
C2:C12	List	=Dump!$B$2:$B$600

 

[GraH]

Thanks for the data, that's more chance for you getting a useful answer. I'll have a look later when I have some time.

 

[Kulo5856]

Thanks for the data, that's more chance for you getting a useful answer. I'll have a look later when I have some time.

Thanks and awaiting for your answer, please take a time and complete the formula for my stock ledger
do the needfull..

 

[GraH]

Hi, I did had a closer look at it, but I got lost in the data and the array formulae and gave up. I kind of expected others to jump in too.
I'll try again now, but can't promise anything.