Cell reference according to cell position

[Frederik074]

Hi,
I want to put reference on cells for example three cells away each other and references are for example two or four cells away each other. How can I do that?
Thank you


Image:

 

[Robert Mika]

If hat helps:
In D2:

=IF(MOD(ROWS($A$1:$A1),5)=1,OFFSET(A1, 1, 0, 1, 1),"")

copy down.

 

[Frederik074]

The formula contains an error:

 

[VoG]

You posted an image. This is absolutely useless to anybody who wishes to copy your sheet. Try Excel Jeanie http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[Robert Mika]

Frederik in some countries you need to change "," (coma) to ";" (semicolon).
Maybe that will work in your case

 

[Frederik074]

I changed commas and this is result:

[RANGE=cls:xl2bb-100][XR][XH=cs:5]Excel Workbook[/XH][/XR][XR][XH][/XH][XH]A[/XH][XH]B[/XH][XH]C[/XH][XH]D[/XH][/XR][XR][XH]1[/XH][XD=h:l]New York[/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]2[/XH][XD][/XD][XD][/XD][XD][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A1);5)=1;OFFSET(A1; 1; 0; 1; 1);"")]XXX[/FORMULA][/XD][/XR][XR][XH]3[/XH][XD][/XD][XD][/XD][XD][/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A2);5)=1;OFFSET(A2; 1; 0; 1; 1);"")][/FORMULA][/XD][/XR][XR][XH]4[/XH][XD=h:l]XXX[/XD][XD][/XD][XD][/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A3);5)=1;OFFSET(A3; 1; 0; 1; 1);"")][/FORMULA][/XD][/XR][XR][XH]5[/XH][XD=h:l]Washington[/XD][XD][/XD][XD][/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A4);5)=1;OFFSET(A4; 1; 0; 1; 1);"")][/FORMULA][/XD][/XR][XR][XH]6[/XH][XD][/XD][XD][/XD][XD][/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A5);5)=1;OFFSET(A5; 1; 0; 1; 1);"")][/FORMULA][/XD][/XR][XR][XH]7[/XH][XD][/XD][XD][/XD][XD][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A6);5)=1;OFFSET(A6; 1; 0; 1; 1);"")]XXX[/FORMULA][/XD][/XR][XR][XH]8[/XH][XD][/XD][XD][/XD][XD=h:l]XXX[/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A7);5)=1;OFFSET(A7; 1; 0; 1; 1);"")][/FORMULA][/XD][/XR][XR][XH]9[/XH][XD=h:l]Boston[/XD][XD=h:l]XXX[/XD][XD][/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A8);5)=1;OFFSET(A8; 1; 0; 1; 1);"")][/FORMULA][/XD][/XR][XR][XH]10[/XH][XD=h:l]XXX[/XD][XD][/XD][XD][/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A9);5)=1;OFFSET(A9; 1; 0; 1; 1);"")][/FORMULA][/XD][/XR][XR][XH]11[/XH][XD][/XD][XD][/XD][XD=h:l]XXX[/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A10);5)=1;OFFSET(A10; 1; 0; 1; 1);"")][/FORMULA][/XD][/XR][XR][XH]12[/XH][XD][/XD][XD][/XD][XD][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A11);5)=1;OFFSET(A11; 1; 0; 1; 1);"")]0[/FORMULA][/XD][/XR][XR][XH]13[/XH][XD=h:l]XXX[/XD][XD=h:l]XXX[/XD][XD][/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A12);5)=1;OFFSET(A12; 1; 0; 1; 1);"")]XXX[/FORMULA][/XD][/XR][XR][XH]14[/XH][XD=h:l]XXX[/XD][XD][/XD][XD][/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A13);5)=1;OFFSET(A13; 1; 0; 1; 1);"")]XXX[/FORMULA][/XD][/XR][XR][XH]15[/XH][XD=h:l]XXX[/XD][XD][/XD][XD][/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A14);5)=1;OFFSET(A14; 1; 0; 1; 1);"")][/FORMULA][/XD][/XR][XR][XH]16[/XH][XD][/XD][XD][/XD][XD][/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A15);5)=1;OFFSET(A15; 1; 0; 1; 1);"")][/FORMULA][/XD][/XR][XR][XH]17[/XH][XD=h:l]Dallas[/XD][XD][/XD][XD][/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A16);5)=1;OFFSET(A16; 1; 0; 1; 1);"")]XXX[/FORMULA][/XD][/XR][XR][XH]18[/XH][XD][/XD][XD][/XD][XD][/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A17);5)=1;OFFSET(A17; 1; 0; 1; 1);"")][/FORMULA][/XD][/XR][XR][XH]19[/XH][XD=h:l]XXX[/XD][XD=h:l]XXX[/XD][XD][/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A18);5)=1;OFFSET(A18; 1; 0; 1; 1);"")][/FORMULA][/XD][/XR][XR][XH]20[/XH][XD][/XD][XD=h:l]XXX[/XD][XD][/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A19);5)=1;OFFSET(A19; 1; 0; 1; 1);"")][/FORMULA][/XD][/XR][XR][XH]21[/XH][XD][/XD][XD][/XD][XD][/XD][XD=h:l|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A20);5)=1;OFFSET(A20; 1; 0; 1; 1);"")]XXX[/FORMULA][/XD][/XR][XR][XH]22[/XH][XD][/XD][XD][/XD][XD][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(ROWS($A$1:$A21);5)=1;OFFSET(A21; 1; 0; 1; 1);"")]0[/FORMULA][/XD][/XR][XR][XH=cs:5][RANGE][XR][XD]Sheet1[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE]