Formula?

[Fortissima]

I have a column of 100 random numbers valued 1 to 5. Is there a formula
that will list the occurence of each number? For example - 41 1's, 38 2's,
11 3's, 7 4's and 3 5's.

 

[Don Guillett]

Have a look at the COUNTIF function

 

[Gord Dibben]

With your data range is A1:A100, key in 1,2,3,4,5 in cells B1:B5.

Then select a range of 5 open contiguous cells(say C1:C5) and insert this
formula in the active cell.

=FREQUENCY(A1:A100,B1:B5) and press ctrl+shift+enter.


Gord Dibben Excel MVP

 

[Ken Wright]

Pivot table will do that in literally 30 seconds, just make sure the column has
a header and then drag that field into both the ROW and DATA fields and then
ensure you get a COUNT and not SUM by right clicking on the table, choosing
field settings and changing SUM to COUNT.

http://peltiertech.com/Excel/Pivots/pivotstart.htm