Fill down

[robert_woodie]

i have some formulas, =a10,=a20=a30 etc. i cannot make it auto fill down
i have tried selecteing between 2 and 5 cells in the sequence

any ideas??
robert

 

[Jason Morin]

You'll have to use a formula. If you're starting in row 1
and filling down, try:

=OFFSET($A$10,ROW()*10-10,)

For any row, use:

=OFFSET($A$10,ROW()*10-10*R,)

where R is the row that the formula starts in. For
example, starting in row 8, the formula would be:

=OFFSET($A$10,ROW()*10-80,)

HTH
Jason
Atlanta, GA