Different Nos. of rows to be use as Parameters in array functions.

[Bhawani]

if the Product_Godown_Status is fix (Column G) then out put in (Column I) should be equal to stock where Fixed_Product_Godown_ID is equal to Mall_ID AND maximum date against that product
If the Product_Godown_Status is not fixed then maximum stock against that product_id
How ever my attempt is in (column I) giving wrong result, correct result manually updated in column J
I know this will be done by some array function with (sumproduct) but unable to use it.
Product wise cells are highlighted maximum rows will be 50 only
if you see cells - i3, i7, i10, i15, i19 having differnet formula because of nos. of Mall_id, nos of Prod_Id would be different(variable).
Please help me out

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[bosco_yip]

Another option,

In L3, formula copy down :

=AGGREGATE(OR(G3="fix",H3=E3)+14,6,F$3:F$22/(C$3:C$22=C3),1)

Regards

 

[Bhawani]

thanks you both, now firstly i will understand one of the function and will implement one of these.

probably i will use difficult one