One more methos.

Assuming your digits are in A1:A100

In B1:B5 enter digits 1 through 5.

Select C1:C5

In activecell C1 enter =FREQUENCY(A1:A100,B1:B5) and hit CTRL + SHIFT + ENTER

Excel will place curly brackets around the formula because it is an ARRAY
formula.

The frequency of each number in B1:B1 will be returned to C1:C5


Gord Dibben MS Excel MVP

On Thu, 2 Feb 2006 11:29:32 -0800, "dykstra_sj"
wrote:

In a column I have a list of numbers (1-5) and I want to know how many 1s,
2s, 3s, etc. What is the formula?