Formula required

[vvinod]

Version	Line Type	Ingredient	Qty MT
3	Product	G	20
3	Ingredient	B	15
3	Ingredient	C	5

Is there any formula in excel 2019 to take output as Ingredient B 75% and ingredient C 25% against the product G and version 3

 

[myall_blues]

Can you show us what you want your output to look like?

 

[vvinod]

Version	Line Type	Ingredient	Qty MT	Ingredient %
3	Product	G	20
3	Ingredient	B	15	75%
3	Ingredient	C	5	25%

 

[myall_blues]

Book1
	A	B	C	D	E
1
2	Version	Line Type	Ingredient	Qty MT	Ingredient %
3	3	Product	G	20
4	3	Ingredient	B	15	75%
5	3	Ingredient	C	5	25%
Sheet2

Cell Formulas
Range	Formula
E4:E5	E4	=D4/D$3

 

[vvinod]

No man there are 1000 line items with different product code different version so required a formula to calculate

 

[myall_blues]

So tell us exactly what you need with sample data of more than one line.
For example, how do we know that ingredients B and C belong to product G?

 

[Cubist]

Perhaps this. Try:

Book1
	A	B	C	D	E
1
2	Version	Line Type	Ingredient	Qty MT	Ingredient %
3	3	Product	G	20
4	3	Ingredient	B	15	0.75
5	3	Ingredient	C	5	0.25
6	4	Product	G	50
7	4	Ingredient	B	25	0.5
8	4	Ingredient	C	25	0.5
Sheet2

Cell Formulas
Range	Formula
E3:E8	E3	=IF(B3="Product","",D3/MAXIFS($D$3:$D$8,$B$3:$B$8,"Product",$A$3:$A$8,A3))

 

[vvinod]

Thank You