skip rows

I have a data table like this, column A2:A27. How can I put in B2 value from
A2, in B3 value from A7, in B4 value from A12, etc.

130.15
9999
9999
9999
9999
130.25
9999
9999
9999
9999
130.35
9999
9999
9999
9999
130.45
9999
9999
9999
9999
130.55
9999
9999
9999
9999
130.65

One way:

B2: =INDEX(A:A,(ROW()-2)*5+2)

copy down as far as needed.

In article <[email protected]>,
marat <[email protected]> wrote:

> I have a data table like this, column A2:A27. How can I put in B2 value from
> A2, in B3 value from A7, in B4 value from A12, etc.
>
> 130.15
> 9999
> 9999
> 9999
> 9999
> 130.25
> 9999
> 9999
> 9999
> 9999
> 130.35
> 9999
> 9999
> 9999
> 9999
> 130.45
> 9999
> 9999
> 9999
> 9999
> 130.55
> 9999
> 9999
> 9999
> 9999
> 130.65