counting values in a column

[Jerry]

I have a spreadsheet that I need to count values in a column. For instance
Column A has the following values 1,15,3,45,1,1,15,20,3,10. I need to create
another worksheet containing the answer as follows:
Column A Column B
1 3
3 2
10 1
15 2
20 1
45 1
Your assistance is greatly appreciated

 

[Beverly]

Hi Jerry,

You can use the "countif" function for that. The formula for cell B2 would
be:

=countif($a:$a,a2)

When you copy the formula down, a2 will become a3, a4, etc. and the value
you're counting will change accordingly.

Beverly

 

[B Lynn B]

Pivot table!