空白在上面或下面 (10260)


E2:F15 {=IFERROR(INDEX(B:B,RIGHT(SMALL(($C$2:$C$14<>"")/1%%%+$B$2:$B$14/1%+ROW($2:$14),ROW(A1)),2)),"")


I2:J15 {=IFERROR(INDEX(B:B,RIGHT(SMALL(($C$2:$C$14="")/1%%%+$B$2:$B$14/1%+ROW($2:$14),ROW(A1)),2)),"")


留言