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???

"TotallyConfused" wrote:

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???

I am sorry but I forgot to add that in the series of dates a date value maybe
missing so I need to have my formula also include blanks when needed. Thank
you again for any help anyone can give me please.

"TotallyConfused" wrote:

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???

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???

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???

In B1: =IF(MOD(ROWS($1:1),4),MOD(ROWS($1:1),4),"")

copy down as far as needed


"TotallyConfused" wrote:

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???