Have column of nums, need qty of each?
 

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

Have column of nums, need qty of each?
 

=COUNTIF(A1:A15,B1) this works for a specific range


=COUNTIF(A:A,B1) this is for a specific column


Place this formula in B2
B1 you will enter the number you want counted


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

Have column of nums, need qty of each?
 

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

Have column of nums, need qty of each?
 

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 Laanemets


"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