Have column of nums, need qty of each?

S

samckitt

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
 
D

davesexcel

=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
 
V

Vasant Nanavati

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.
 
A

Arvi Laanemets

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
 
Top