E2:J5{=IF(COLUMN(A1)>SUM(N(LOOKUP(ROW($2:$99),ROW($2:$99)/ISNUMBER(-LEFT($A$2:$A$99)),LEFT($A$2:$A$99)*1)*($A$2:$A$99<>"")=ROW(A1))),"",INDEX($A:$A,SMALL(IF(1-ISERR(-LEFT($A$2:$A$99)),ROW($2:$99)),ROW(A1))+COLUMN(A1)-1))
另解{=INDEX($A:$A,SMALL(IF(ROW(A1)=--LOOKUP(ROW(2:99),ROW(2:99)/ISNUMBER(-LEFT($A$2:$A$99)),LEFT($A$2:$A$99)),ROW($2:$99),999),COLUMN(A1)))&""
留言
張貼留言