Thread: skip rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
marat
 
Posts: n/a
Default 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