Thank you so much for responding so quickly - very much appreciated. I
entered the formula you provided and this is what I got back

1
39357
39397

39403
39403
39403

Why am I not getting back the following:???

1
2
3

1
2
3


"Ashish Mathur" wrote:

Hi,

Try this

Against 01/01/08, enter 1 (in the next column), say B1. In the row below
(I.e. B2), enter the following formula
=IF(COUNTBLANK(A2)=1,"",MAX($B$1:B1)+1)

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"TotallyConfused" wrote in
message ...
I have columns instead of rows with data. Transpose does not work with
this.

Ad DT
Dis DT
Ap Dt

01/01/08
02/01/08
03/01/08

05/01/08
06/01/08
07/01/07

and so forth. I wan to be able to flag 1st date as 1, 2nd as 2 and 3rd as
3. In between there are blank rows. How do I do this please???