FROGGER24
Well-known Member
- Joined
- May 22, 2004
- Messages
- 704
- Office Version
- 2013
- 2010
- Platform
- Windows
Column "A" has the Object name, Column "B" is Index #,Column "C" is Index2,Column "D" is STs and Column "E" is level.
Look at A2 & B2, looking at column C for Index # copy the values in columns D & E and place in columns I & J The value in A2 will fill down in column H the rows will be variable length.
thanks
Look at A2 & B2, looking at column C for Index # copy the values in columns D & E and place in columns I & J The value in A2 will fill down in column H the rows will be variable length.
OBJECT | INDEX # | INDEX2 | STs | LEVEL |
FMT 3035 | 1 | 1 | 7 | 1.9167 |
FMT 3037 | 1 | 1 | 29 | 2.0000 |
FMT 3062 | 2 | 1 | 50 | 2.0833 |
FMT 3064 | 2 | 1 | 72 | 2.1667 |
FMT 3066 | 2 | 1 | 94 | 2.2500 |
FMT 3068 | 2 | 1 | 116 | 2.3333 |
FMT 3070 | 2 | 1 | 138 | 2.4167 |
FMT 3072 | 2 | 1 | 160 | 2.5000 |
thanks