Home |
Search |
Today's Posts |
#1
|
|||
|
|||
nonsequential cell references
I am creating a formula on shet one that occurs on every other line but needs
to refer to cells on sheet 2 that are sequential. How can I reference those cells? |
#2
|
|||
|
|||
I ran this formula in the odd rows of Sheet2, beginning with A1 and
referencing sequential cells on Sheet1, beginning with A1: =OFFSET(Sheet1!$A$1,MAX(0,ROW(A1)/2),0) So... Sheet2!A1 refers to Sheet1!A1 Sheet2!A3 refers to Sheet1!A2 etc Is that something you can work with? -- Regards, Ron |
#3
|
|||
|
|||
Actually, this also works:
=OFFSET(Sheet2$A$1,ROW(A1)/2,0) (Enter formula in Sheet1!A1 and copy to A3, A4, etc) -- Regards, Ron |
#4
|
|||
|
|||
Enter this formula in A1 *and* A3 of Sheet1.
=INDEX(Sheet2!A:A,(ROW()+1)/2) NOW, select A1 to A4. Click on the fillhandle of the 4 cell *selection*. and drag down to copy as needed. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jim" wrote in message ... I am creating a formula on shet one that occurs on every other line but needs to refer to cells on sheet 2 that are sequential. How can I reference those cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) | |||
finding all references to a cell | Excel Discussion (Misc queries) | |||
Excel change SUM references if you cut & paste the first cell in SUM... | Excel Discussion (Misc queries) | |||
Sheet Names and Cell References | Excel Worksheet Functions | |||
Changing Cell References in Formulas | Excel Worksheet Functions |