| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Help
How do i do the following i want to do a fill where it fills every 5th cell
example A1 =1 A2 = 2 A3= 3 A4=4 A5 = 5 etc I want to then do B1 = A1, B2 = A5, B3 = A10, etc. How do i do this with out doing it manually? Thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fill Help
In B1: =A1
In B2: =INDIRECT(ADDRESS((ROW()-1)*5,1)) Copy B2 down as needed. Hope this helps, Hutch "Justin" wrote: How do i do the following i want to do a fill where it fills every 5th cell example A1 =1 A2 = 2 A3= 3 A4=4 A5 = 5 etc I want to then do B1 = A1, B2 = A5, B3 = A10, etc. How do i do this with out doing it manually? Thanks, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fill Help
Ok that works except that it always gives column A, how do i have it give me
column D, or column C in another sheet? "Tom Hutchins" wrote: In B1: =A1 In B2: =INDIRECT(ADDRESS((ROW()-1)*5,1)) Copy B2 down as needed. Hope this helps, Hutch "Justin" wrote: How do i do the following i want to do a fill where it fills every 5th cell example A1 =1 A2 = 2 A3= 3 A4=4 A5 = 5 etc I want to then do B1 = A1, B2 = A5, B3 = A10, etc. How do i do this with out doing it manually? Thanks, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fill Help
The last number in the B2 formula (after the comma) is the number of the
column being referred to. So, to apply the formulas to column D instead of A: In B1: =D1 In B2: =INDIRECT(ADDRESS((ROW()-1)*5,4)) To refer to column C on another sheet (for example, Sheet2): In B1: =Sheet2!C1 In B2: =INDIRECT("Sheet2!" & ADDRESS((ROW()-1)*5,3)) Hope this helps, Hutch "Justin" wrote: Ok that works except that it always gives column A, how do i have it give me column D, or column C in another sheet? "Tom Hutchins" wrote: In B1: =A1 In B2: =INDIRECT(ADDRESS((ROW()-1)*5,1)) Copy B2 down as needed. Hope this helps, Hutch "Justin" wrote: How do i do the following i want to do a fill where it fills every 5th cell example A1 =1 A2 = 2 A3= 3 A4=4 A5 = 5 etc I want to then do B1 = A1, B2 = A5, B3 = A10, etc. How do i do this with out doing it manually? Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Some formulas don't track copies, pastes, fill right, fill down | Excel Discussion (Misc queries) | |||
| Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
| Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
| The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
Hybrid Mode
