| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Offset formula
Thanks - I was on the wrong track completely!
"Domenic" wrote: Assuming that Sheet1!A1:Z1 contains the data, try... A1, copied across: =INDEX('Sheet1'!$A1:$Z1,COLUMNS($A1:A1)*3-3+1) Adjust the sheet reference and range for your data accordingly. Hope this helps! In article , Ken G. wrote: I have two worksheets. The first worksheet has data in every 4th column ie a, d, g, j, etc that I want to bring in to columns a,b,c,d etc on the second sheet. Using the offset function I either need to move the reference cell each time or move the offset itself. How can I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Offset formula on different worksheet | Excel Worksheet Functions | |||
| VLOOKUP, SUM, OFFSET and IF formula all at once | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
Threaded Mode
