Copied Cells do not run Series consecutively...


G

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 D2:D4) are copying a cell
reference (A2) stored as a number from a previous sheet. The next three
rows (Cells D5:D7) copy the next cell reference (A3)(one below) in the
same sheet. And the last three rows (Cells D8:D10) 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.
 
Ad

Advertisements

B

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top