Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incrementing cell reference
I have created a spreadsheet that has four rows of data which are analysing a
set of information from a pivot table usign teh get pivot command. The information being bought back is delivered by a cell on the far left (every four lines), which refers to a value in another sheet. I have repeated these four rows down the page to allow a series of data to be analysed, I would expect the first four lines data to be ='1 Base'!A2 then the next cell (four rows later) to display ='1 Base'!A3. However Excel is instead incrementing it to ='1 Base'!A7. I have tried changing the value manually and then filling down, in the hope that it will pick up the pattern, but this does not work. Any suggestions? There will be too many rows to manually correct. -- Paul Mugleston Data Officer from the UK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incrementing cell reference
You can use INDIRECT or OFFSET to do this, both described in Excel
Help. Hope this helps. Pete On Jan 10, 3:54*pm, Paul Mugleston wrote: I have created a spreadsheet that has four rows of data which are analysing a set of information from a pivot table usign teh get pivot command. *The information being bought back is delivered by a cell on the far left (every four lines), which refers to a value in another sheet. I have repeated these four rows down the page to allow a series of data to be analysed, I would expect the first four lines data to be ='1 Base'!A2 then the next cell (four rows later) to display ='1 Base'!A3. * However Excel is instead incrementing it to ='1 Base'!A7. *I have tried changing the value manually and then filling down, in the hope that it will pick up the pattern, but this does not work. Any suggestions? *There will be too many rows to manually correct. -- Paul Mugleston Data Officer from the UK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incrementing cell reference in Lookup formula | Excel Worksheet Functions | |||
incrementing mm/yy based on value in other cell | Excel Worksheet Functions | |||
Incrementing Cell Numbers | Excel Discussion (Misc queries) | |||
incrementing formula reference by 7 | Excel Discussion (Misc queries) | |||
Incrementing rows (or columns) to a reference in another worksheet | Excel Worksheet Functions |