software

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: www.excelforum.com/member.php...oamp;userid=33089
View this thread: www.excelforum.com/showthread...hreadid=528989
=COUNTIF(A1:A15,B1) this works for a specific range=COUNTIF(A:A,B1) this is for a specific columnPlace this formula in B2
B1 you will enter the number you want counted--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=528989If 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.quot;samckittquot; gt; wrote in
message ...
gt;
gt; I have a column of a couple of thousands of numbers and I need a quick
gt; easy way to figure the qty of each number in the column. Is there an
gt; easy way to do this in Excel?
gt; Thanks,
gt; Scot
gt;
gt;
gt; --
gt; samckitt
gt; ------------------------------------------------------------------------
gt; samckitt's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33089
gt; View this thread: www.excelforum.com/showthread...hreadid=528989
gt;
Hi

Create a pivot table based on column (as field in pivot table). In pivot
layout sheet, set row=field, and data=(count of field ). Its all.Arvi Laanemetsquot;samckittquot; gt; wrote in
message ...
gt;
gt; I have a column of a couple of thousands of numbers and I need a quick
gt; easy way to figure the qty of each number in the column. Is there an
gt; easy way to do this in Excel?
gt; Thanks,
gt; Scot
gt;
gt;
gt; --
gt; samckitt
gt; ------------------------------------------------------------------------
gt; samckitt's Profile:
www.excelforum.com/member.php...oamp;userid=33089
gt; View this thread: www.excelforum.com/showthread...hreadid=528989
gt;