dragging formula to make selection
 

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.

dragging formula to make selection
 

On Jul 30, 9:52 pm, memobile wrote:
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

dragging formula to make selection
 

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


"memobile" wrote:

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.