How to rank values based on multiple criteria.

[IVANAROS]

I have the spreadsheet below .
Based on the criteria I would like to get a report similar to what I have entered manually on the columns L to N

If the minimum time Is met for the event and appropriate age group then the top ranked athletes can join the available slots ,
If the time for two athletes that are ranking at the bottom of the minimum entry is the same there is an exception and an additional position is created +n ,
The automatic entry time rule ignores the available positions and as long as athletes reach the minimum entry time they can also join
Age groups include u15,u17,u20,senior,master (male and female) how can I do this ?
Also can this be auto generated for each age group, gender and event/ how ?

Thanks

 

[philaugust2004]

The image is far too small for me to see

 

[IVANAROS]

Apologies that should be better

 

[IVANAROS]

Formulas that I use
<code>L14 =INDEX($A$1:$A$11,SMALL(IF($E$2:$E$11<12,ROW($E$2:$E$11)),ROW(1:1)))
</code>It doesn't take into account age group and gender and doesn't sort only expected results. also not auto generated based on event
<code> M14 =INDEX(E3:E11,MATCH(M24,A3:A11,0))

N12 =CONCATENATE("Report U 17 M 100M ", M20, " Positions free out of Y( total numbers that meet the minimum time)")

M20= INDEX(J3:J11,MATCH("Number of places in the team"&"U17 M",H3:H11&I3:I11, 0))
</code>The automatic report is not working as you can see..