View Single Post
  #2   Report Post  
Rowan
 
Posts: n/a
Default

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