H2:H9{=IFERROR(OFFSET(A$1,RIGHT(SMALL(IF(RIGHT(SMALL(LEN(B$2:F$5)-LEN(SUBSTITUTE(B$2:F$5,",",))+1+{1;2;3;4}/1%,ROW($1:$4)*5))-COLUMN(A:E)>=0,ROW($1:$4)+COLUMN(A:E)/1%),ROW(A1))),),"")
I2:M9=IF($H2="","",TRIM(MID(SUBSTITUTE(VLOOKUP($H2,$A:$F,COLUMN(B1),),",",REPT(" ",9)),COUNTIF($H$2:$H2,$H2)*9-8,9)))
留言
張貼留言