Excel formula reference question
 

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

Excel formula reference question
 

Try this in B1:

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

and copy down.

Hope this helps.

Pete

On Jan 17, 2:58*pm, Gerben Dirksen wrote:
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

Excel formula reference question
 

Great, exactly what I was looking for.

Thanks!

Gerben

Pete_UK wrote:
Try this in B1:

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

and copy down.

Hope this helps.

Pete

On Jan 17, 2:58�pm, Gerben Dirksen wrote:
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

Excel formula reference question
 

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


"Gerben Dirksen" wrote:

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

Excel formula reference question
 

You're welcome - thanks for feeding back.

Pete

On Jan 17, 3:16Â*pm, Gerben Dirksen wrote:
Great, exactly what I was looking for.

Thanks!

Gerben



Pete_UK wrote:
Try this in B1:

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

and copy down.

Hope this helps.

Pete

On Jan 17, 2:58�pm, Gerben Dirksen wrote:
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- Hide quoted text -

- Show quoted text -