Why not just use a formula

=COUNTIF(A:A,A1)

and copy down

--
HTH

Bob Phillips

"Noemi" wrote in message
...
I have a row of numbers that can be repeated multiple times.

I would like to be able to count how many times the first number is listed
and continue all the way through until no more numbers a left to check.

eg
6
32
32
7
45
23
23
7
54

how do I write a program to go through each number and check how many
times
that number is listed in the row.
The numbers always very so I cannot use a set value.

Thanks
Noemi