If you know the number you are looking for (e.g., 2146), you can use
something like:

=COUNTIF(A:A,2146)

If you want the frequency of occurrence of all unique numbers (without
knowing in advance what they are), you will probably need some code.


"samckitt" wrote in
message ...

I have a column of a couple of thousands of numbers and I need a quick
easy way to figure the qty of each number in the column. Is there an
easy way to do this in Excel?
Thanks,
Scot


--
samckitt
------------------------------------------------------------------------
samckitt's Profile:
http://www.excelforum.com/member.php...o&userid=33089
View this thread: http://www.excelforum.com/showthread...hreadid=528989