count the number of times the same number shown
 

We have a list of numbers (which can vary) in a row that can have the some
number multiple times.

I would like to count the number of times each number is shown.

Can someone suggest an easy way of doing this.

Thanks
Noemi

Lets say your data is in Row1 starting in cell A1. In cell A2 enter the
formula
=COUNTIF(1:1,A1)
and copy it accross. This will give you a count for each number.

Alternately if your data is in a column eg Column A, in cell B2 place
the formula
=COUNTIF(A:A,A1)
and copy it down. Again this will give you a count for each number.

Hope this helps
Rowan

Noemi wrote:
We have a list of numbers (which can vary) in a row that can have the some
number multiple times.

I would like to count the number of times each number is shown.

Can someone suggest an easy way of doing this.

Thanks
Noemi