各組自行排序 (14256)

N2:Y9=SMALL(OFFSET($A2,,INT((COLUMN(A1)-1)/3)*3,,3),MOD(COLUMN(A1)-1,3)+1)

N14:Y21{=SMALL(IF(LOOKUP(COLUMN(A:L),COLUMN(A:L)/($A$13:$L$13<>""),$A$13:$L$13)=LOOKUP("座",$A$13:A$13),$A14:$L14),COLUMN(A1)-LOOKUP(1,0/($N$13:N$13<>""),COLUMN($A:A))+1)