to cause the current formula to "auto-fill" down the side of another column,
simply enter the formula in the first row, and then double click the small
dark box in the lower right of the cell.

Was this your question?

"Arlene" wrote:

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