View Single Post
  #1   Report Post  
Arlene
 
Posts: n/a
Default Help One Way did not work

The reply to my problem below did bring the variable over to column b,
however, the fill option repeats the same variable in row 1 and does not
extract the data in every 3rd row. What do you mean by copy down? nine
thousand records!

One way:

B1: =INDEX(A:A,(ROW()-1)*3+1)


Copy down.

In article ,
Arlene wrote:

need step by step instructions to extract data from column A starting with A1
and grab A4, A7, A10, A13, etc.



--
ALFR