合併格未出現姓名 提出 (14764)

E2{=INDEX(TRIM(MID(SUBSTITUTE(B$2,CHAR(10),REPT(" ",99)),ROW($1:$19)*99-98,99)),SMALL(IF(COUNTIF(C$2:C$8,TRIM(MID(SUBSTITUTE(SUBSTITUTE(B$2,CHAR(10)," ")," ",REPT(" ",99)),ROW($1:$19)*198-99,99)))=0,ROW($1:$19)),ROW(A1)))&""