(先) B2 下拉{=IFERROR(MID(INDEX(TRIM(MID(SUBSTITUTE(F$2,CHAR(10),REPT(" ",99)),ROW($1:$5)*99-98,99)),SMALL(IF((0&LEFT(TRIM(MID(SUBSTITUTE(F$2,CHAR(10),REPT(" ",99)),ROW($1:$5)*99-98,99))))-COLUMN(A:I)>=0,ROW($1:$5)),ROW(A1))),3,9),"")
A2=IF(B2="","",E$2)
留言
張貼留言