| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto expand rows | Excel Worksheet Functions | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| Automatically inserting rows | Excel Worksheet Functions | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Linear Mode
