前後 3名 (11092)


H3:K8{=ABS(LARGE(IF(ROW(A1)>3,-1,1)*B$2:B$14,MOD(ROW(A3),3)+1))


H12:K17{=INDEX($A:$A,RIGHT(ABS(LARGE(IF(ROW(A1)>3,-1,1)*(B$2:B$14/1%+ROW($2:$14)),MOD(ROW(A3),3)+1)),2))


留言