Copied Cells do not run Series consecutively...

[Gucci]

I'm hoping someone can help me out with a problem I have...

I am trying to copy a series of formulas from 9 rows above. It would
make sense to use the fill handle to highlight the formulas and copy
down the series. But the series, is not running the formulas
consecutively.

For example the first three rows (Cells D24) are copying a cell
reference (A2) stored as a number from a previous sheet. The next three
rows (Cells D57) copy the next cell reference (A3)(one below) in the
same sheet. And the last three rows (Cells D810) copy or link to the
next cell reference (A4)( one below, again ). I just want the fill
handle to continue this process or series.

But for some reason, it starts the formula by jumping down to the
eleventh cell reference on the previous sheet (skipping over cell 4
through 10 ). I've tried everything to continue the series including
the Edit, Fill, Series function (linear and growth with and with out
Trend).

What am I missing? I'd like to get this done with having to type up all
these missing rows myself.

 

[Biff]

Hi!

Not sure exactly what you want. It sounds like you want to repeat a
reference to a cell 3 times then increment the reference to the next cell:

D2 = =A2
D3 = =A2
D4 = =A2
D5 = =A3
D6 = =A3
D7 = =A3
D8 = =A4
D9 = =A4
D10 = =A4
D11 = =A5
D12 = =A5
D13 = =A5
etc

If that's what you want:

=INDEX(A$2:A$10,CEILING(ROWS($1:1)/3,1))

Biff

 

[Gucci]

Biff,

That worked very well for me! Your input is very much appreciated.

Gus

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Biff,

That worked very well for me! Your input is very much appreciated.

Gus