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,"")
Thanks in advance.
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,"")

Thanks in advance.