判斷二班別結合 (12652)

V3:X7{=IFERROR(LOOKUP(1,0/(SUM(SMALL(IF(OFFSET($A$3,,MATCH($T$2,$1:$1,)-1,30)=$U3,COUNTIF(OFFSET($A$3,,,ROW($1:$30)),"<>")),{1,2})*{10,1})={12,13,23}),{"早午","早晚","午晚"}),"")