H2:H13{=INDEX(A:A,SMALL(IF(RIGHT(SMALL(LEN(B$2:F$7)-LEN(SUBSTITUTE(B$2:F$7,",",))+(B$2:F$7<>"")+ROW(2:7)/1%,ROW($1:$6)*5))-COLUMN(A:I)>=0,ROW($2:$7),99),ROW(A1)))&""
I2:M13=IF($H2="","",TRIM(MID(SUBSTITUTE(VLOOKUP($H2,$A:$F,COLUMN(B1),),",",REPT(" ",99)),COUNTIF($H$2:$H2,$H2)*99-98,99)))
留言
張貼留言