<p>=SUM((MATCH($A$1:$A$15,$A$1:$A$15,0)=ROW($A$1:$A$15))*1)</p><p>=SUM((COUNTIF($A$1:$A$15,$A$1:$A$15)=1)*1)</p><p>=SUM((COUNTIF($A$1:$A$15,$A$1:$A$15)=2)*0.5)</p><p>=SUM((COUNTIF($A$1:$A$15,$A$1:$A$15)>1)*1)-SUM((MATCH($A$1:$A$15,$A$1:$A$15,0)<>ROW($A$1:$A$15))*1)</p><p>第四条臭一点,实现想不出了[em04]</p>
[此贴子已经被作者于2008-1-18 4:12:19编辑过] |