Excel formula series
 

I have tried various ways to increment a formula from one tab to another. Is
there a way to increment a formula being reference on another tab by odds and
evens?
ex. =Sheet2!A2, = Sheet2!A4, etc

Excel formula series
 

Try this for evens:

=INDEX(Sheet2!A:A,2*ROWS($1:1))

And copy down as needed.

For odds:

=INDEX(Sheet2!A:A,2*ROWS($1:1)-1)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"questioningj" wrote in message
...
I have tried various ways to increment a formula from one tab to another.
Is
there a way to increment a formula being reference on another tab by odds
and
evens?
ex. =Sheet2!A2, = Sheet2!A4, etc

Excel formula series
 

In the first cell, say cell C11, enter:

=INDIRECT("Sheet2!A" & (ROW(C11)-ROW($C$10))*2)

Note the relationship between the C11 and the $C$10....

Then copy down.

If you want to copy across, use Column instead of Row and $B$11 instead of $C$10....

HTH,
Bernie
MS Excel MVP


"questioningj" wrote in message
...
I have tried various ways to increment a formula from one tab to another. Is
there a way to increment a formula being reference on another tab by odds and
evens?
ex. =Sheet2!A2, = Sheet2!A4, etc

Excel formula series
 

Thanks for your help. I believe this answer solved my problem.

"RagDyer" wrote:

Try this for evens:

=INDEX(Sheet2!A:A,2*ROWS($1:1))

And copy down as needed.

For odds:

=INDEX(Sheet2!A:A,2*ROWS($1:1)-1)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"questioningj" wrote in message
...
I have tried various ways to increment a formula from one tab to another.
Is
there a way to increment a formula being reference on another tab by odds
and
evens?
ex. =Sheet2!A2, = Sheet2!A4, etc