| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Leaving a cell blank
I have a range of cells (A1 to F1) that I fill with dates. In cell A1 I put
the date in (8/24/08) then use the control,+ and ; keys to drag the dates across to the end or last cell. Now, How can I do this and skip one cell? A1=8/24 A2=8/25 A3= skip the cell I want to leave it blank A4= 8/26 A5=Etc thanks, Art |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Leaving a cell blank
Is it just one cell that you want to leave blank or every third cell? If
every third cell then enter: =IF(MOD(ROW(),3)=0,"",LOOKUP(10^10,$A$1:A1)+1) In A2, format the cell as a Date then drag down on the fill handle. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Skip cell with dates" <Skip cell with wrote in message ... I have a range of cells (A1 to F1) that I fill with dates. In cell A1 I put the date in (8/24/08) then use the control,+ and ; keys to drag the dates across to the end or last cell. Now, How can I do this and skip one cell? A1=8/24 A2=8/25 A3= skip the cell I want to leave it blank A4= 8/26 A5=Etc thanks, Art |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Leaving a cell blank
Sandy,
It's only one cell.Starting with B1 and ending with G1. I would like to leave D1 blank. Have the dates skip over this cell. Art "Sandy Mann" wrote: Is it just one cell that you want to leave blank or every third cell? If every third cell then enter: =IF(MOD(ROW(),3)=0,"",LOOKUP(10^10,$A$1:A1)+1) In A2, format the cell as a Date then drag down on the fill handle. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Skip cell with dates" <Skip cell with wrote in message ... I have a range of cells (A1 to F1) that I fill with dates. In cell A1 I put the date in (8/24/08) then use the control,+ and ; keys to drag the dates across to the end or last cell. Now, How can I do this and skip one cell? A1=8/24 A2=8/25 A3= skip the cell I want to leave it blank A4= 8/26 A5=Etc thanks, Art |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Leaving a cell blank
Shorter version:
=IF(COLUMN(B1)=3,"",MAX(A1:B1)+1) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Sandy Mann" wrote in message ... In C1 enter: =IF(COLUMN(B1)=3,"",IF(COLUMN(B1)=4,A1+1,B1+1)) and copy across to G1. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Skip cell with dates" wrote in message ... Sandy, It's only one cell.Starting with B1 and ending with G1. I would like to leave D1 blank. Have the dates skip over this cell. Art "Sandy Mann" wrote: Is it just one cell that you want to leave blank or every third cell? If every third cell then enter: =IF(MOD(ROW(),3)=0,"",LOOKUP(10^10,$A$1:A1)+1) In A2, format the cell as a Date then drag down on the fill handle. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Skip cell with dates" <Skip cell with wrote in message ... I have a range of cells (A1 to F1) that I fill with dates. In cell A1 I put the date in (8/24/08) then use the control,+ and ; keys to drag the dates across to the end or last cell. Now, How can I do this and skip one cell? A1=8/24 A2=8/25 A3= skip the cell I want to leave it blank A4= 8/26 A5=Etc thanks, Art |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Leaving a cell blank
Thanks so much! Works like a charm.
Art "Sandy Mann" wrote: In C1 enter: =IF(COLUMN(B1)=3,"",IF(COLUMN(B1)=4,A1+1,B1+1)) and copy across to G1. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Skip cell with dates" wrote in message ... Sandy, It's only one cell.Starting with B1 and ending with G1. I would like to leave D1 blank. Have the dates skip over this cell. Art "Sandy Mann" wrote: Is it just one cell that you want to leave blank or every third cell? If every third cell then enter: =IF(MOD(ROW(),3)=0,"",LOOKUP(10^10,$A$1:A1)+1) In A2, format the cell as a Date then drag down on the fill handle. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Skip cell with dates" <Skip cell with wrote in message ... I have a range of cells (A1 to F1) that I fill with dates. In cell A1 I put the date in (8/24/08) then use the control,+ and ; keys to drag the dates across to the end or last cell. Now, How can I do this and skip one cell? A1=8/24 A2=8/25 A3= skip the cell I want to leave it blank A4= 8/26 A5=Etc thanks, Art |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make an input in a cell mandatory without leaving it blank | Excel Discussion (Misc queries) | |||
| Colouring Ranges & Leaving Cells Blank | Excel Discussion (Misc queries) | |||
| Leaving a cell blank when there is an error message - HELP | Excel Discussion (Misc queries) | |||
| Leaving a cell blank. Not NA(), not "". | Excel Worksheet Functions | |||
| prevent a user leaving a blank cell in excel2003 | Excel Discussion (Misc queries) | |||
Linear Mode
