彙整各班相聚 且排序 (15281)

F2:H19{=INDEX(B:B,RIGHT(SMALL(FIND($C$2:$C$19,"1 班2 班3 班")*10^6+COUNTIFS($C$2:$C$19,$C$2:$C$19,$D$2:$D$19,">"&$D$2:$D$19)/1%+ROW($2:$19),ROW(A1)),2))