=INDEX(FILTER(TOCOL(TOCOL(B3:B12&"-"&TRANSPOSE(C3:C10))&"-"&TRANSPOSE(D3:D11)),MAP(TOCOL(TOCOL(B3:B12&"-"&TRANSPOSE(C3:C10))&"-"&TRANSPOSE(D3:D11)),LAMBDA(x,IF(AND(INDEX(--TEXTSPLIT(x,"-"),,1)<INDEX(--TEXTSPLIT(x,"-"),,2),INDEX(--TEXTSPLIT(x,"-"),,2)<INDEX(--TEXTSPLIT(x,"-"),,3)),1,0)))=1),RANDBETWEEN(1,COUNTA(FILTER(TOCOL(TOCOL(B3:B12&"-"&TRANSPOSE(C3:C10))&"-"&TRANSPOSE(D3:D11)),MAP(TOCOL(TOCOL(B3:B12&"-"&TRANSPOSE(C3:C10))&"-"&TRANSPOSE(D3:D11)),LAMBDA(x,IF(AND(INDEX(--TEXTSPLIT(x,"-"),,1)<INDEX(--TEXTSPLIT(x,"-"),,2),INDEX(--TEXTSPLIT(x,"-"),,2)<INDEX(--TEXTSPLIT(x,"-"),,3)),1,0)))=1))))
|