You can do it with a formula

=INDEX(A:A,(ROW(A1)-1)*15+1)

and so on

--
__________________________________
HTH

Bob

"jlo" wrote in message
...
I have a spreadsheet and I am trying to develop a list from that
spreadsheet.
I need Excel to find the data in every 15th row in column A.

For instance Column A is Name, Column B is Address. I want to generate a
list of every name in Column A for every 15th record.

Would I need a formula, macro or code?

Thanks in advance.