=Indirect("A" & (row()-1)*7+2) in B1 then drag fill down.

--
Regards,
Tom Ogilvy

"Jeff" wrote in message
...
Hi,
I have a column of data from A2 to A65000 and I am only interested in
every 7th data point (e.g. A2, A9, A16....). Is there a way to get those
selected points and store them in the next column (B) consecutviely (b1,
b2,
b3, b4, ...)?

Thanks,

Jeff