Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula from consecutive rows to alternate rows?
I have a worksheet with data in consecutive rows.
I have another worksheet into which I want to insert a formula on every second row, but referring to each consecutive row in the first worksheet. For example, on Worksheet 1, in column A: Row 1: 123 Row 2: 456 Row 3: 789 etc On Worksheet 2 I want to show: Row 1: ='Worksheet 1'!A1 Row 2: Row 3: ='Worksheet 2'!A2 Row 4: Row 5: ='Worksheet 3'!A3 How do I copy the above formula down? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula from consecutive rows to alternate rows?
In Sheet2 cell A1 copy th ebelow formula and copy down as required
=IF(MOD(ROW(),2)=1,INDEX(Sheet1!A:A,CEILING(ROW()/2,1)),"") -- Jacob "Neville Bailey" wrote: I have a worksheet with data in consecutive rows. I have another worksheet into which I want to insert a formula on every second row, but referring to each consecutive row in the first worksheet. For example, on Worksheet 1, in column A: Row 1: 123 Row 2: 456 Row 3: 789 etc On Worksheet 2 I want to show: Row 1: ='Worksheet 1'!A1 Row 2: Row 3: ='Worksheet 2'!A2 Row 4: Row 5: ='Worksheet 3'!A3 How do I copy the above formula down? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula from consecutive rows to alternate rows?
Thank you Jacob - that worked perfectly!
"Jacob Skaria" wrote: In Sheet2 cell A1 copy th ebelow formula and copy down as required =IF(MOD(ROW(),2)=1,INDEX(Sheet1!A:A,CEILING(ROW()/2,1)),"") -- Jacob "Neville Bailey" wrote: I have a worksheet with data in consecutive rows. I have another worksheet into which I want to insert a formula on every second row, but referring to each consecutive row in the first worksheet. For example, on Worksheet 1, in column A: Row 1: 123 Row 2: 456 Row 3: 789 etc On Worksheet 2 I want to show: Row 1: ='Worksheet 1'!A1 Row 2: Row 3: ='Worksheet 2'!A2 Row 4: Row 5: ='Worksheet 3'!A3 How do I copy the above formula down? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color alternate rows when after hiding selected rows | Excel Worksheet Functions | |||
Transposing data from consecutive rows into non-consecutive rows | Excel Discussion (Misc queries) | |||
sum alternate rows | Excel Worksheet Functions | |||
Add alternate rows | Excel Worksheet Functions | |||
How to sum-up alternate rows ? | Excel Worksheet Functions |