Formula question

[Ed]

OK, here is the problem:
I have a worksheet, a very large worksheet that looks like this:

Column a
1
1
1
2
2
2
2
2
3
3
3

I need a formula that tells me how many ones, how many 2s, and how many 3s
are in the column. I have about 1 million numbers and need to apply the
formula to the entire column.

Thanks

 

[Gary''s Student]

=COUNTIF(A:A,ROWS($B$1:B1)) and copy down

 

[Ron Rosenfeld]

OK, here is the problem:
I have a worksheet, a very large worksheet that looks like this:

Column a
1
1
1
2
2
2
2
2
3
3
3

I need a formula that tells me how many ones, how many 2s, and how many 3s
are in the column. I have about 1 million numbers and need to apply the
formula to the entire column.

Thanks

For just 1's, 2's and 3's, you could use countif:

=countif(a:a,1)

If there are a large number of unique numbers, you might want to look at using
a Pivot Table.
--ron