B5:H11{=IFERROR(IF(ROW(A1)=1,LEFT(B2,5),MAX(((SMALL(IF(ISNA(MATCH(ROW($1:$24),(0&TEXT(TRIM(MID(SUBSTITUTE(B$2,CHAR(10),REPT(" ",99)),ROW($1:$15)*99-98,99)),"H"))*1,)),"",ROW($1:$24)),ROW(A1))+1)/24-IFERROR(TRIM(MID(SUBSTITUTE(B$2,CHAR(10),REPT(" ",99)),ROW($1:$15)*99-98,99))*1,1)>0)*IFERROR(TRIM(MID(SUBSTITUTE(B$2,CHAR(10),REPT(" ",99)),ROW($1:$15)*99-98,99))*1,1))),"")
留言
張貼留言