Thread: skip rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default skip rows

One way:

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

copy down as far as needed.

In article ,
marat 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