Drag formula sequence

**Scrubber** · 12-17-2009, 01:14 PM

Hi everyone. I tried searching for a post similar to mine, but I'm not real sure of the verbiage to use. It is most likely an easy answer, I just can't find it via my Google or forum searching

Basically I'm just trying to fill a formula sequence to continue the series, but apparently I'm missing something. For example, if I was trying to drag cells containing the 3 simple formulas below downward, I would expect it to continue the series with =A7, =A9, =A11, etc. Instead it fills it with =A4, =A6, =A8, etc., and I'm not quite sure why. Thanks in advance for your help with my stupid question.

=A1
=A3
=A5

**DonkeyOte** · 12-17-2009, 01:25 PM

Perhaps

=INDEX(A:A,1+2*(ROWS(A$1:A1)-1))
copied down

**JBeaucaire** · 12-17-2009, 01:29 PM

Put this formula in the first cell, then copy it down:

=INDEX(A:A, (ROW()*2)-1)

**Scrubber** · 12-17-2009, 02:02 PM

These are both working solutions, and after playing with them I believe they can be formatted to do what I need to do. Thanks to both of you for your assistance!