Please help with Column to row formatting

[TotallyConfused]

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]

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]

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.

 

[Ashish Mathur]

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]

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

 

[TotallyConfused]

Thank you for your help. However, I am not getting what I need. I need to
identify each series of dates with a number like this. Thank you

Ad DT
Dis DT
Ap Dt New Column

01/01/08 1
02/01/08 2
03/01/08 3

05/01/08 1
06/01/08 2
07/01/07 3

 

[Teethless mama]

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

copy down as far as needed

 

[Roger Govier]

Hi

I was assuming that you you had the following
A1 Ad DT
A2 Dis DT
A3 Ap dt
A4 (blank)
A5 01/01/08
A6 02/01/08
A7 03/01/08
A8 (blank)
A9 05/01/08
I also assumed that B4 was Blank, the same as A4

In which case, I cannot see why you don't get in B5 1, B6 2, B7 3, B8
(blank), B9 1