Prev: How do I e-mail 1 page of a multi page workbook
Next: Random Numbers
From: Neville Bailey on 25 Mar 2010 09:21
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?
From: Jacob Skaria on 25 Mar 2010 09:33
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?
From: Neville Bailey on 25 Mar 2010 09:58
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?
 | 
Pages: 1
Prev: How do I e-mail 1 page of a multi page workbook
Next: Random Numbers