Excel cell name number adding -

i confuse explain question/problem, best so.

i want write formula display value cell jumping cell in particular sequence.

e.g. column d =a1 =a6 =a11 =a16 ----- ---- ----- 

it sequence of 5 cells write 2 rows formula =a1 , =a6 , drag formula , got as

=a1 =a6 =a3 =a8 

anyone please guide me.

you can use offset() , row()

=offset($a$1,(row()-1)*5,0) 

paste in d1 , copy down

as example if have in a values correspond row numbers you'll following sample outcome

  | b  | c  |   d ------------------ 1  |    |    |   1 2  |    |    |   6 3  |    |    |  11 4  |    |    |  16 5  |    |    |  21 6  |    |    |  26 7  |    |    |  31 8  |    |    |  36 9  |    |    |  41 ... 

explanation:

offset() returns reference range specified number of rows , columns cell or range of cells.
row() returns row number of reference.

therefore formula evaluated to:

• for d1 - go 0 ((1-1)*5) rows , 0 columns a1 a1 (1+0)
• for d2 - go 5 ((2-1)*5) rows , 0 columns a1 a6 (1+5)
• for d3 - go 10 ((3-1)*5) rows , 0 columns a1 a11(1+10)
• etc