<div>
or this one:<br />
<a href="http://www.get-digital-help.com/2009/06/09/count-unique-values-in-a-column-in-excel/" rel="ugc">http://www.get-digital-help.com/2009/06/09/count-unique-values-in-a-column-in-excel/</a>
</div>


<div>
Sort your column with numbers eg.Col-A<br />
Type this formula on the first row =(A1&lt;&gt;A2)*1 and copy that to the end of the data row 22.000.<br />
Nou Sum this column and you have the number of diferences :-)
</div>


<div>
If data is in A1:A22000 try this formula in an adjacent column<br />
<br />
=SUMPRODUCT((A1:A22000&lt;&gt;&quot;&quot;<wbr />)/COUNTIF(<wbr />A1:A22000,<wbr />A1:A22000&amp;<wbr />&quot;&quot;))<br />
<br />
That will count the number of different values in the range while ignoring (and not counting) and blanks<br />
<br />
regards, barry
</div>


<div>
im sure the others worked. however I found this to be the easiest
</div>


<div>
<div class="content wysiwyg-content">
i have a spreadsheet. and in the spreadsheet I have a column with 22,000 line items. (1 - 22,000). however, when I highlight the column, I can see the &quot;count&quot;, sum&quot;, etc... <br />
<br />
I want to know is how many different numbers are there in this column. I can see many duplicate numbers (for billing purposes). there are just too many lines items to do this manually<br />
<br />
. is there a formula I can use ?<br />
<br />
thank you
</div>
</div>


i have a spreadsheet. and in the spreadsheet I have a column with 22,000 line items. (1 - 22,000). however, when I highlight the column, I can see the "count", sum", etc... 

I want to know is how many different numbers are there in this column. I can see many duplicate numbers (for billing purposes). there are just too many lines items to do this manually

. is there a formula I can use ?

thank you

or this one:
http://www.get-digital-help.com/2009/06/09/count-unique-values-in-a-column-in-excel/

Sort your column with numbers eg.Col-A
Type this formula on the first row =(A1&lt;&gt;A2)*1 and copy that to the end of the data row 22.000.
Nou Sum this column and you have the number of diferences :-)

If data is in A1:A22000 try this formula in an adjacent column

=SUMPRODUCT((A1:A22000&lt;&gt;&quot;&quot;)/COUNTIF(A1:A22000,A1:A22000&amp;&quot;&quot;))

That will count the number of different values in the range while ignoring (and not counting) and blanks

regards, barry

im sure the others worked. however I found this to be the easiest

how to figure out about many different numbers in a column

i have a spreadsheet. and in the spreadsheet I have a column with 22,000 line items. (1 - 22,000). however, when I highlight the column, I can see the &quot;count&quot;, sum&quot;, etc... 

I want to know is how many different numbers are there in this column. I can see many duplicate numbers (for billing purposes). there are just too many lines items to do this manually

. is there a formula I can use ?

thank you

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