| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference question | Excel Discussion (Misc queries) | |||
| I just don't get it please help relative reference question | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| question about cell reference in a formula | Excel Discussion (Misc queries) | |||
| Reference question | Excel Worksheet Functions | |||
Linear Mode
