count the number of times the same number shown

N

Noemi

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
 
R

Rowan

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
 
Top