原例是数据在A、B列，无标题将C列作为辅助列C1单元格输入公式=A1&B1下拉再用以下公式统计“B列是1的，对应A列中不重复项的个数”=SUMPRODUCT((INDIRECT("B1:B"&COUNTA(C:C))=1)*1/COUNTIF(INDIRECT("C1:C"&COUNTA(C:C)),INDIRECT("C1:C"&COUNTA(C:C))))
