Excel formula series

Q

questioningj

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
 
R

RagDyer

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!
==============================================
 
B

Bernie Deitrick

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
 
Top