二項相同, 回傳多筆 聚單元格 (11672)

D2右拉 下拉 {=IFERROR(IF(COLUMN(A1)=1,"",",")&INDEX($A:$A,SMALL(IF(SUBSTITUTE(LOWER(SUBSTITUTE($A2&$B2,CHAR(10),))," ",)=SUBSTITUTE(LOWER(SUBSTITUTE($B$12:$B$14&$C$12:$C$14,CHAR(10),))," ",),{12;13;14}),COLUMN(A1)))&E2,"")



留言