Large function with criteria.

  • Hello,

    I have been learning excel and found it interesting using the functions. Doing so I am stuck in a situation where I have to use a LARGE function with a criteria to select a specific value.
    Please fetch the attached file Grid India - Cable Selection.xlsx and refer the below points.

    Notes
    :
    Yellow cells are the Input values consisting of manual input in (C4) and drop down selection in (D4:G4)
    Green is where I need the final output (I4).

    Problem faced :
    Red is the cell I need to work on. Here the next LARGE value (w.r.t. C4) popping up should also fulfill the criterias of all other yellow cells (input cells).

    Please guide me.
    Thanks!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!