|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 30th, 2010, 04:52 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need some help with auto-fill
Im trying to get autofill to fill dates in batches of ten after each
other, but with little success. like so... Is there anyone who can help me with this? 2009-01-01 2009-01-01 2009-01-01 2009-01-01 2009-01-01 2009-01-01 2009-01-01 2009-01-01 2009-01-01 2009-01-01 2009-01-02 2009-01-02 2009-01-02 2009-01-02 2009-01-02 2009-01-02 2009-01-02 2009-01-02 2009-01-02 2009-01-02 2009-01-03 
|
|
#2
April 30th, 2010, 05:02 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need some help with auto-fill
With your starting date in A1 formatted how you would like, put this
formula in A2: =IF(COUNTIF(A$1:A1,A1)10,0,1)+A1 and then copy it down as far as you need to. Hope this helps. Pete On Apr 30, 4:52*pm, Per Carlsson wrote: Im trying to get autofill to fill dates in batches of ten after each other, but with little success. like so... Is there anyone who can help me with this? 2009-01-01 2009-01-01 2009-01-01 2009-01-01 2009-01-01 2009-01-01 2009-01-01 2009-01-01 2009-01-01 2009-01-01 2009-01-02 2009-01-02 2009-01-02 2009-01-02 2009-01-02 2009-01-02 2009-01-02 2009-01-02 2009-01-02 2009-01-02 2009-01-03
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
