dragging formula to make selection

[memobile]

hi, i need to drag a formula down a column which selects every tenth cell
from another column, please. for example in column d3:d102 i need to have
every 10th entry in column a3:a1002. thanks for your time.

 

[Ken Johnson]

hi, i need to drag a formula down a column which selects every tenth cell
from another column, please. for example in column d3:d102 i need to have
every 10th entry in column a3:a1002. thanks for your time.

Maybe...

=OFFSET($A$3,(ROWS($1:1)-1)*10+9,0,1,1)

Ken Johnson

 

[John C]

The following formula in D3, drag down as needed:
=INDEX($A$3:$A$1002,(ROW()-3)*10+1,1)