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.
|