排序複雜 各區各時段取最小 (14665)

D2=SUMPRODUCT((B$2:B$16=B2)*(HOUR(C$2:C$16)=HOUR(C2))*(C$2:C$16<C2))

E2:F11{=IFERROR(INDEX(B:B,RIGHT(SMALL(IF($D$2:$D$16=0,CODE($B$2:$B$16)/1%%+HOUR($C$2:$C$16)/1%+ROW($2:$16)),ROW(A1)),2)),"")