Hi

In cell B1 enter 1
In cell B2 enter
=IF(A2="","",IF(A2=A1,B1+1,1))
and copy down as far as required

--
Regards

Roger Govier


"Wessel" wrote in message
...
Hi, would anybody be able to think of an equation for this? Let's say
that in
Column A I have 10 of the same number. (e.g. A1-A10 is taken up by
3372 ten
times over)
And after that under that I have another number 15 times over (e.g.
5050
from A11-A25). How can I make Excel (in column B) automatically number
the
first list of the same number 1-10, and the following list 1-15?
Any solutions will be much appreciated!