<div>
Try this array formula<br />
<br />
=SUM(IF(FREQUENCY(IF(LEN(A<wbr />2:A100)&gt;0,<wbr />MATCH(A2:A<wbr />100,A2:A10<wbr />0,0),&quot;&quot;), IF(LEN(A2:A100)&gt;0,MATCH(A2<wbr />:A100,A2:A<wbr />100,0),&quot;&quot;)<wbr />)&gt;0,1))
</div>


Try this array formula

=SUM(IF(FREQUENCY(IF(LEN(A2:A100)>0,MATCH(A2:A100,A2:A100,0),""), IF(LEN(A2:A100)>0,MATCH(A2:A100,A2:A100,0),""))>0,1))

<div>
Great! Short to the point! Thank you!
</div>


<div>
<div class="content wysiwyg-content">
Hi! Column A1:A25000 has data. This data has duplicates. How do I count total values excluding the repeating numbers? Thanks! P.S. I have Excel 2010.
</div>
</div>


Hi! Column A1:A25000 has data. This data has duplicates. How do I count total values excluding the repeating numbers? Thanks! P.S. I have Excel 2010.

Match formula for duplicate values

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.