楼主的意思是统计各数据出现的次数吗,那首先就得先列出它们然后统计其出现的次数。假设数据区在A2至A21,则具体步骤如下一、列出数据(重复数据只列1次),在B2输入公式:B2=IF(ROW(INDIRECT("1:"&ROWS(A2:A21)))<=SUM(1/COUNTIF(A2:A21,A2:A21)),INDEX(A2:A21,SMALL(IF(MATCH($A$2:$A$21,$A$2:$A$21,0)=ROW(INDIRECT("1:"&ROWS(A2:A21))),ROW(INDIRECT("1:"&ROWS(A2:A21))),""),ROW(INDIRECT("1:"&SUM(1/COUNTIF(A2:A21,A2:A21
|