how do you select every 8th cell

[JBW]

I want to grab the data from cells A2/A10/A18 etc
I thought if I did the first few and then selected them all and copied that
excel would get the idea and grab every 8th one, but it doesn't
Is there a formala that can say get cell that is previous one plus 8 rows?

 

[bj]

what do you mean by "get"?
do you want to sum?
=sumproduct(--(mod(row(A2:A200),8)=2),A2:A200)
do you want the data to show in another location
=index(A:A,(row()-1)*8+2
put into row 1 and copied down.

there are other options depending on what you want to do.

 

[David Biddulph]

=OFFSET(A$2,8*(ROW(A1)-1),0) and copy down.

 

[JBW]

Fantastic

thanks

what do you mean by "get"?
do you want to sum?
=sumproduct(--(mod(row(A2:A200),8)=2),A2:A200)
do you want the data to show in another location
=index(A:A,(row()-1)*8+2
put into row 1 and copied down.

there are other options depending on what you want to do.