四格同時出現姓名 (9122)


D2{=IFERROR(INDEX(TRIM(MID(SUBSTITUTE(B$2, ",",REPT(" ",99)),ROW($1:$9)*99-98,99)),SMALL(IF(MMULT({1,1,1},1-ISERR(FIND(","&TRIM(MID(SUBSTITUTE(B$2, ",",REPT(" ",99)),COLUMN(A:I)*99-98,99))&",",","&B$3:B$5&",")))=3,COLUMN($A:I)),ROW(A1))),"")


留言