1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

Discussion in 'Ask an Excel Question' started by Bhawani, Mar 20, 2017.

  1. Bhawani

    Bhawani Member

    Messages:
    138
    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

    Attached Files:

  2. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,035
    Hi ,

    See the attached file.

    Narayan

    Attached Files:

    Thomas Kuriakose likes this.
  3. bosco_yip

    bosco_yip Well-Known Member

    Messages:
    1,154
    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

    Attached Files:

    Thomas Kuriakose likes this.
  4. Bhawani

    Bhawani Member

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

    probably i will use difficult one ;)

Share This Page