| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AutoFill with sheet reference help
Tell me where to send the beer... Thanks a ton!!!
"T. Valko" wrote: Assume you enter the first formula on some sheet in cell A1: =INDEX(Sheet1!A:A,CEILING(ROWS(A$1:A1)/3,1)) Copy down as needed. -- Biff Microsoft Excel MVP "TimeCloud" wrote in message ... I am trying to use autofill to copy a sheet reference as follows: =sheet1!a1 =sheet1!a1 =sheet1!a1 =sheet1!a2 =sheet1!a2 =sheet1!a2 =sheet1!a3 =sheet1!a3 =sheet1!a3 The autofill can't figure out my pattern and will not fill in the formula properly it skips numbers. TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill a Sheet Reference | Excel Worksheet Functions | |||
| How to reference different worksheets in an autofill formula | Excel Discussion (Misc queries) | |||
| reference autofill. | Excel Worksheet Functions | |||
| Relative reference autofill increment other than +1 | Excel Discussion (Misc queries) | |||
| Autofill/Reference Confusion | Excel Worksheet Functions | |||
Linear Mode
