ExcelBanter - skip rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - skip rows (https://www.excelbanter.com/excel-worksheet-functions/83053-skip-rows.html)

marat

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

JE McGimpsey

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

All times are GMT +1. The time now is 03:51 PM.