E2:G11{=INDEX(TRIM(MID(SUBSTITUTE(A2,"，",REPT(" ",99)),ROW($1:$9)*99-98,99)),RIGHT(MAX(IFERROR((TRIM(MID(SUBSTITUTE(IF($D2,$A2,$C2),"，",REPT(" ",99)),ROW($1:$9)*99-98,99))-IF($D2,$D2,4^8)<=0)*TRIM(MID(SUBSTITUTE(IF($D2,$A2,$C2),"，",REPT(" ",99)),ROW($1:$9)*99-98,99))/1%+ROW($1:$9),)),2))
留言
張貼留言