Your formula works, I screwed it up when I applied to actual data. My fault
totally. Sorry:)

"Mike H" wrote:

what didn't work about it?

"kraway" wrote:

That didn't work but I think I have the idea now.

"Mike H" wrote:

OOps your step was 5 not 6 so I really meant this!!

=INDEX(A:A,(ROW(A1)-1)*5+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?