;=3,A1:B3,\"\",MATCH(0,頻率(IF(COUNTIF(A1:" />
TEXTJOIN(",",TRUE,IF(COUNTIF(A1:B3,a 1:B3)& gt;=3,A1:B3,"")
用上面的公式替換紅框中的A1:A10。
TEXTJOIN(",",TRUE,INDEX(IF(COUNTIF(A1:B3,a 1:B3)>;=3,A1:B3,"",MATCH(0,頻率(IF(COUNTIF(A1:B3,a 1:B3)>;=3,A1:B3,""),IF(COUNTIF(A1:B3,a 1:B3)>;=3,A1:B3,""),0)))
滿意請給分。謝謝妳,老板。