how do you select every 8th cell
 

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?

how do you select every 8th cell
 

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.

"JBW" wrote:

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?

how do you select every 8th cell
 

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

"JBW" wrote in message
...
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?

how do you select every 8th cell
 

Fantastic

thanks

"bj" wrote:

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.

"JBW" wrote:

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?