Sequential numbering

Originally Posted by EH003268

I have a list in column A, and I would like to create the number the Column B for each change in A. Does anyone have a formular.

A B
01/01/2007 1
01/01/2007 2
01/01/2007 3
02/01/2007 1
02/01/2007 2
02/01/2007 3
02/01/2007 4
03/01/2007 1
03/01/2007 2

Thanks

Hi try this in col B

=COUNTIF($A$1:A1,A1) and drag it down

Originally Posted by EH003268

That's perfect.
Thanks a lot

you're welcome
thanks for the feedback.