referencing the data in a cell
 

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?

referencing the data in a cell
 

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?

referencing the data in a cell
 

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?

referencing the data in a cell
 

Hi,

=OFFSET($A$1,(ROW()-1)*5,0)

HTH

referencing the data in a cell
 

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?

referencing the data in a cell
 

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?

referencing the data in a cell
 

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?

referencing the data in a cell
 

No problem, thank you for the feedback

Mike

"kraway" wrote:

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?

Kraway:

Paste this formula in cell B1 and copy down as far as needed.

Paste this formula in cell C1 and copy down, hide column B.