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
|