D2{=IFERROR(MID(B$2,SMALL(IF((MID(","&B$2,ROW($1:$98),1)=",")*ISERR(-MID(B$2,ROW($1:$98),1)),ROW($1:$98)),ROW(A1)),MATCH(1=0,ISERR(-MID(B$2&9,SMALL(IF((MID(","&B$2,ROW($1:$98),1)=",")*ISERR(-MID(B$2,ROW($1:$98),1)),ROW($1:$98)),ROW(A1))+ROW($1:$19)-1,1)),)-1),"")
留言
張貼留言