| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Skipping Cells
I am using two sheets of information. In the second sheet I want to take a
cell from Sheet one and then skip down cells in sheet one to get the next cell. Is there any way to create a formula that will do that? Sheet A30 235-364 A60 211-354 I want to create formula that will allow me to get these two cells without having go back to Sheet 1 every single time |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Skipping Cells
=Sheet!A1
or have I missed something? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "CellSkipper" wrote in message ... I am using two sheets of information. In the second sheet I want to take a cell from Sheet one and then skip down cells in sheet one to get the next cell. Is there any way to create a formula that will do that? Sheet A30 235-364 A60 211-354 I want to create formula that will allow me to get these two cells without having go back to Sheet 1 every single time |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Skipping Cells
What I want is to take Cell A1 and Cell A31 and Cells A61 from Sheet 1 to
Sheet 2 in one move. I want to take information from every 30th cell. "Bernard Liengme" wrote: =Sheet!A1 or have I missed something? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "CellSkipper" wrote in message ... I am using two sheets of information. In the second sheet I want to take a cell from Sheet one and then skip down cells in sheet one to get the next cell. Is there any way to create a formula that will do that? Sheet A30 235-364 A60 211-354 I want to create formula that will allow me to get these two cells without having go back to Sheet 1 every single time |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Skipping Cells
If you are on a different sheet:
=INDEX(Sheet1!$A:$A,(ROWS(Sheet1!$1:1)-1)*30+COLUMNS(Sheet1!$A:B)-1) If you are on the same sheet: =INDEX($A:$A,(ROWS($1:1)-1)*30+COLUMNS($A:B)-1) Then, fill down... Regards, Ryan--- -- RyGuy "CellSkipper" wrote: What I want is to take Cell A1 and Cell A31 and Cells A61 from Sheet 1 to Sheet 2 in one move. I want to take information from every 30th cell. "Bernard Liengme" wrote: =Sheet!A1 or have I missed something? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "CellSkipper" wrote in message ... I am using two sheets of information. In the second sheet I want to take a cell from Sheet one and then skip down cells in sheet one to get the next cell. Is there any way to create a formula that will do that? Sheet A30 235-364 A60 211-354 I want to create formula that will allow me to get these two cells without having go back to Sheet 1 every single time |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Skipping Cells
In Sheet2 A1 enter =Sheet1!A1
In Sheet2 A2 enter =OFFSET(Sheet1!$A$1,30*ROW()-30,0) Drag/copy A2 down as far as you wish. Gord Dibben MS Excel MVP On Fri, 25 Jan 2008 13:03:02 -0800, CellSkipper wrote: What I want is to take Cell A1 and Cell A31 and Cells A61 from Sheet 1 to Sheet 2 in one move. I want to take information from every 30th cell. "Bernard Liengme" wrote: =Sheet!A1 or have I missed something? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "CellSkipper" wrote in message ... I am using two sheets of information. In the second sheet I want to take a cell from Sheet one and then skip down cells in sheet one to get the next cell. Is there any way to create a formula that will do that? Sheet A30 235-364 A60 211-354 I want to create formula that will allow me to get these two cells without having go back to Sheet 1 every single time |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Skipping Cells
Whoops!
Don't need the =Sheet1!A1 in A1 Enter =OFFSET(Sheet1!$A$1,30*ROW()-30,0) in A1 then copy down. Gord On Fri, 25 Jan 2008 13:35:19 -0800, Gord Dibben <gorddibbATshawDOTca wrote: In Sheet2 A1 enter =Sheet1!A1 In Sheet2 A2 enter =OFFSET(Sheet1!$A$1,30*ROW()-30,0) Drag/copy A2 down as far as you wish. Gord Dibben MS Excel MVP On Fri, 25 Jan 2008 13:03:02 -0800, CellSkipper wrote: What I want is to take Cell A1 and Cell A31 and Cells A61 from Sheet 1 to Sheet 2 in one move. I want to take information from every 30th cell. "Bernard Liengme" wrote: =Sheet!A1 or have I missed something? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "CellSkipper" wrote in message ... I am using two sheets of information. In the second sheet I want to take a cell from Sheet one and then skip down cells in sheet one to get the next cell. Is there any way to create a formula that will do that? Sheet A30 235-364 A60 211-354 I want to create formula that will allow me to get these two cells without having go back to Sheet 1 every single time |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference row on another sheet skipping zeros but not skipping li. | Excel Discussion (Misc queries) | |||
| Fill down while skipping cells | Excel Worksheet Functions | |||
| Fill down while skipping cells | Excel Worksheet Functions | |||
| skipping cells | Excel Discussion (Misc queries) | |||
| Skipping Blank Cells | Excel Discussion (Misc queries) | |||
Linear Mode
