E2{=IFERROR(INDEX(TRIM(MID(SUBSTITUTE(B$2,",",REPT(" ",99)),(ROW($1:$19)*2-1)*99-98,99)),SMALL(IF(COUNTIF(E$1:E1,TRIM(MID(SUBSTITUTE(B$2,",",REPT(" ",99)),(ROW($1:$19)*2-1)*99-98,99)))=0,ROW($1:$19)),1)),"")
F2{=IF(E2="","",SUM(IF(TRIM(MID(SUBSTITUTE(B$2,",",REPT(" ",99)),(ROW($1:$19)*2-1)*99-98,99))=E2,(0&TRIM(MID(SUBSTITUTE(B$2,",",REPT(" ",99)),(ROW($1:$19)*2)*99-98,99)))*1)))
留言
張貼留言