ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I make a formula that uses the fist cell as a starting posi (https://www.excelbanter.com/excel-discussion-misc-queries/22444-how-do-i-make-formula-uses-fist-cell-starting-posi.html)

mrbshansen

How do I make a formula that uses the fist cell as a starting posi
 
How do I make a formula that uses the fist cell as a starting position and
then counts 4 cells down as the next result?

Ex.
A1 start cell, then A5, A9, A13, A17 etc.

cheers
Bjarne



Don Guillett

Have a look in help index for OFFSET

--
Don Guillett
SalesAid Software

"mrbshansen" wrote in message
...
How do I make a formula that uses the fist cell as a starting position and
then counts 4 cells down as the next result?

Ex.
A1 start cell, then A5, A9, A13, A17 etc.

cheers
Bjarne






All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com