Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following formula that offset values from the "Loop 4" sheet. This
formula allows me to offset values every three columns from the same row (17). Therefore, this is what I have typed in my cells to call this data: =OFFSET('Loop 4'!AM$17,0,3) =OFFSET('Loop 4'!AM$17,0,6) =OFFSET('Loop 4'!AM$17,0,9) =OFFSET('Loop 4'!AM$17,0,12) =OFFSET('Loop 4'!AM$17,0,15) .......... .......... .......... .......... =OFFSET('Loop 4'!AM$17,0,60) However, I was given 1000 more values under the "Loop 4" sheet. I have started adding these functions manually in each cells because I could not array the function to change the column number (every three value) only. I wonder if anybody knows the way to do it array this function so I do not have to do manually. Thanks in advance. Maperalia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I use "offset" function in "array formula"? | Excel Discussion (Misc queries) | |||
Use of Offset function in array formula | Excel Worksheet Functions | |||
Array Offset Function | Excel Worksheet Functions | |||
using offset with array formulas | Excel Worksheet Functions | |||
OFFSET and array formulae | Excel Discussion (Misc queries) |