| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to select values in sequence order?
I have a column of values (up to 144 values). I have several other columns
(up to 12 additional columns) that I want to select those values in the first column to fill in the rows on the additional columns. For instance: Column1 Data1 Data2 Data3 Data4 Data5 Data6 Data7 Data8 Column2 Data1 Data2 Column 3 Data3 Data4 Column4 Data5 Data6 Column5 Data7 Data8 I would think this would involve an INDEX formula, but how would I use it? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to select values in sequence order?
No headers in row 1, right?
With the data in A1:Axx Put this in B1: =INDEX($A:$A,2*(COLUMN()-2)+ROW()) and drag down to B2. Then select B1:B2 and drag to the right as far as you need. Scott wrote: I have a column of values (up to 144 values). I have several other columns (up to 12 additional columns) that I want to select those values in the first column to fill in the rows on the additional columns. For instance: Column1 Data1 Data2 Data3 Data4 Data5 Data6 Data7 Data8 Column2 Data1 Data2 Column 3 Data3 Data4 Column4 Data5 Data6 Column5 Data7 Data8 I would think this would involve an INDEX formula, but how would I use it? Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to select values in sequence order?
Why would the data come back showing duplicates? For instance, the last one
listed on the 2nd column would be the first in column 3? "Dave Peterson" wrote: No headers in row 1, right? With the data in A1:Axx Put this in B1: =INDEX($A:$A,2*(COLUMN()-2)+ROW()) and drag down to B2. Then select B1:B2 and drag to the right as far as you need. Scott wrote: I have a column of values (up to 144 values). I have several other columns (up to 12 additional columns) that I want to select those values in the first column to fill in the rows on the additional columns. For instance: Column1 Data1 Data2 Data3 Data4 Data5 Data6 Data7 Data8 Column2 Data1 Data2 Column 3 Data3 Data4 Column4 Data5 Data6 Column5 Data7 Data8 I would think this would involve an INDEX formula, but how would I use it? Thanks -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to select values in sequence order?
I don't know.
Is your data laid out the way I thought it was? Scott wrote: Why would the data come back showing duplicates? For instance, the last one listed on the 2nd column would be the first in column 3? "Dave Peterson" wrote: No headers in row 1, right? With the data in A1:Axx Put this in B1: =INDEX($A:$A,2*(COLUMN()-2)+ROW()) and drag down to B2. Then select B1:B2 and drag to the right as far as you need. Scott wrote: I have a column of values (up to 144 values). I have several other columns (up to 12 additional columns) that I want to select those values in the first column to fill in the rows on the additional columns. For instance: Column1 Data1 Data2 Data3 Data4 Data5 Data6 Data7 Data8 Column2 Data1 Data2 Column 3 Data3 Data4 Column4 Data5 Data6 Column5 Data7 Data8 I would think this would involve an INDEX formula, but how would I use it? Thanks -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula that selects value from list in sequence order | Excel Discussion (Misc queries) | |||
| 2 part macro question (sequence & order) | Excel Worksheet Functions | |||
| Is there an formula to reverse the order of a number sequence? | Excel Discussion (Misc queries) | |||
| list missing values in a sequence | Excel Discussion (Misc queries) | |||
| How do I reverse the order (sequence) of a column of data in Excel | Excel Worksheet Functions | |||
Hybrid Mode
