referencing the data in a cell

[kraway]

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?

 

[Mike H]

Try this in c1 and drag down

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

Mike

 

[Mike H]

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

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

Mike

 

[Carim]

Hi,

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

HTH

 

[kraway]

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

 

[Mike H]

what didn't work about it?

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

 

[kraway]

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

 

[Mike H]

No problem, thank you for the feedback

Mike

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

 

[GoBow777]

I have a column of data, say column A. I want to show the value o
every 5th
row in column A in column C. This means cell C1 will reference cel
A1, cell
C2 will reference cell A6, cell C3 will reference cell A11, etc. I
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.


Code
-------------------
=IF(MOD(ROW()-1,5)=0,ROW(),""
-------------------


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


Code