| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help with Column to row formatting
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??? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please help with Column to row formatting
"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??? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please help with Column to row formatting
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??? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please help with Column to row formatting
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??? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please help with Column to row formatting
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??? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please help with Column to row formatting
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 "Roger Govier" wrote: Hi In cell B5, enter the following and copy down as far as required =IF(A5="","",N(B4)+1) -- Regards Roger Govier "TotallyConfused" wrote in message ... 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??? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please help with Column to row formatting
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??? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please help with Column to row formatting
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 -- Regards Roger Govier "TotallyConfused" wrote in message ... 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 "Roger Govier" wrote: Hi In cell B5, enter the following and copy down as far as required =IF(A5="","",N(B4)+1) -- Regards Roger Govier "TotallyConfused" wrote in message ... 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??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting column | Excel Discussion (Misc queries) | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Formatting a row into a column | Excel Worksheet Functions | |||
| column to column conditional formatting won't work, need formula | Excel Worksheet Functions | |||
| Column Formatting | Excel Worksheet Functions | |||
Linear Mode
