Large in row with multiple criteria and blank cells

[Pofski]

Hello everybody,

i was wondering if there is somebody who could help me with the following problem.
I have a table with multiple conditions.
I would need to find a large (and small) in a table, depending on what is filled in in the first two rows.
Now, the row where the large has to come from has empty cells.

The reason why i would like to use large is because frankly, i prefer it to max :/, and because this will be used to find the top and bottom 3 of certain events for each topic.

I will upload a sample file in a bit as well.

Thank you in advance

 

[Pofski]

So, this is a sample file of what i am looking for.
The data is to be found in column A to D.
I made a collection of all available options from I5 till M14, and underneath that, the score card that will have to be linked to the table data.

 

[Xiq]

Hi Pofski,

Please check attached file. Just point, what should happen if there is no score?

 

[Pofski]

thanks Xig

If there's no score, the area should be left empty, but i will put an if formula on top of your array formula.
Thanks a lot for your help, it's fantastic.