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

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

"Jerry" wrote:

> 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

Pivot table!

"Jerry" wrote:

> 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