Try this in c1 and drag down

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

Mike

"kraway" wrote:

I have a column of data, say column A. I want to show the value of every 5th
row in column A in column C. This means cell C1 will reference cell A1, cell
C2 will reference cell A6, cell C3 will reference cell A11, etc. Is there a
formula that I can drag down column C to produce this result?