Read value from every fourth line

[WayneM]

Hi

I have data in column A cells 1 to 200 for example I want to copy the data from every forth cell say starting at cell 3 and copy the data into another column

I can do this by manualy entering the equation for each required line but is there a smart way?

Wayne

 

[VoG]

Try in B1 copied down

=INDEX(A:A,4*ROW()-1)