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.
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.