出現指定字符數 聚單元格 (15239)

H2{=SUBSTITUTE(SUBSTITUTE(TEXT(SUM(IF(COUNTIF(F:F,B2:D2),B2:D2*100^{2,1,0})),"00!,00!,00;;"),"00,",),",00",)

B2:D16格式化=COUNTIF($F:$F,B2)