Sorting of table

Hi

In the example below on columns N to P I am trying to get a sorted array (smaller to larger) with the following

Automatic entry times if they exist (no limit of entries)
And after that the Minimum entry times follow (limit of entries is specified in P4).

I have sort of done it (tables N-P) as you can see using a temp table (K-L, that I would like to get rid of) but I am getting blank cells and it's not sorted in descending- ascending order automatically it doesn't take the limit into account.

K3 contains = INDEX(A2:A100,MATCH("Senior"&"Male",$B$2:$B$100&$C$2:$C$100, 0))
L2 is a vlookup


P2 =INDEX(I3:I11,MATCH("Automatic entry time"&"Senior"&"Male",F3:F8&G3:G8&H3:H8,0))
P3=INDEX(I3:I11,MATCH("Minimum entry time"&"Senior"&"Male",F3:F8&G3:G8&H3:H8,0))
P4=INDEX(I3:I11,MATCH("Number of places in the team"&"Senior"&"Male",F3:F8&G3:G8&H3:H8,0))


N7=IF(L3 <= $P$2, K3, "")
O7=Vlookup
p7=IF(L3<=$P$2,"Automatic Time", "")

N11=IF(AND(L3<=$P$3,L3>$P$2),K3,"")


925d90281d9f45058fe5db60a5e22777.png

Thanks in advance

Attach a sample workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

attached as requested

How many events in total?

If you want results sorted as per your output then I would have have use helper columns to "sort" the data (acceptable ?) OR VBA.

Maybe others can/will devise formulae solution without helper columns.

Tried to use the helper column with no joy..

In K1-K8 looks ok but still some NAs in K10-K18 tried to get it to only provide the values that match the minimum time but it didn't work as I still get 12 and 13, also it doesn't take into account the number of places, tried a few things and would appreciate some help with the intended solution.

Thanks

Anyone that can help?