Excel formula reference question

[Gerben Dirksen]

Hi, I'm sure this has been asked somewhere but I couldn't find it on
google.

How do I make a large set of formulae that looks like this:

Cell B1: =A5
Cell B2: =A10
Cell B3: =A15
Cell B4: =A20
etc.

Thanks for any help!

Gerben

 

[Pete_UK]

Try this in B1:

=INDIRECT("A"&(ROW(A1)*5))

and copy down.

Hope this helps.

Pete

 

[Gerben Dirksen]

Great, exactly what I was looking for.

Thanks!

Gerben

 

[Teethless mama]

=OFFSET($A$1,ROWS($1:1)*5-1,0)
or
=INDEX(A:A,ROWS($1:1)*5)

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Great, exactly what I was looking for.

Thanks!

Gerben






- Show quoted text -