Russellsky
New Member
- Joined
- Aug 31, 2015
- Messages
- 12
Firstly a massive thank you anybody who is wiling to help me.....
my problem starts with information that has been given to me is very limited but should be enough to solve my problem
i need to identify how many adjacent structures each structure has, basically there will always be one or up to seven
the information given to me is also not in any order so one structure might appear multiple times in one column or alternate
in columns as the sequence is followed, also there might up to maximum of 2 bays between structures
so this is what i have been able to do so far, on sheet two i have merged the two coloums and removed duplicates to give me
a list of all the structures, i have then duplicated information on sheet one but switched the structure ids information for the
duplicated information so that Bay still has the correct structures assigned to it
i have then tried to use index and match back to the first sheet to find the adjacent structures and remove
duplicate structures. in the end i just made a massive stuff up of it and started doing it manually, only problem with that is i have
30 000 to do like this,
please if any body can find it in their heart to help
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
this the format i need to get it to, i have manually done the first 2
<colgroup><col><col span="6"></colgroup><tbody>
</tbody>
my problem starts with information that has been given to me is very limited but should be enough to solve my problem
i need to identify how many adjacent structures each structure has, basically there will always be one or up to seven
the information given to me is also not in any order so one structure might appear multiple times in one column or alternate
in columns as the sequence is followed, also there might up to maximum of 2 bays between structures
so this is what i have been able to do so far, on sheet two i have merged the two coloums and removed duplicates to give me
a list of all the structures, i have then duplicated information on sheet one but switched the structure ids information for the
duplicated information so that Bay still has the correct structures assigned to it
i have then tried to use index and match back to the first sheet to find the adjacent structures and remove
duplicate structures. in the end i just made a massive stuff up of it and started doing it manually, only problem with that is i have
30 000 to do like this,
please if any body can find it in their heart to help
| BAY | Structure 1 Pick ID | Structure 2 Pick ID | |
| B256315 | S1031855 | S1031856 | |
| B256314 | S1031856 | S1031857 | |
| B256313 | S1031857 | S1031858 | |
| B256312 | S1031858 | S1031859 | |
| B256311 | S1031859 | S1031860 | |
| B256310 | S1031860 | S1031861 | |
| B256309 | S1031861 | S1031862 | |
| B1076211 | S1031862 | S1830436 | |
| B1489045 | S1032012 | S2280348 | |
| B254651 | S1039241 | S1039242 | |
| B1076015 | S1039242 | S1830240 | |
| B256692 | S1082299 | S1082300 | |
| B1076257 | S1082300 | S1830478 | |
| B254588 | S1093398 | S1093399 | |
| B1076013 | S1093398 | S1830230 | |
| B256949 | S1093411 | S1093413 | |
| B1379983 | S1093411 | S1909383 | |
| B256951 | S1093412 | S1093414 | |
| B256950 | S1093412 | S1093413 | |
| B1512033 | S1093414 | S2352540 | |
| B256605 | S1132631 | S1132632 | |
| B256606 | S1132632 | S1132634 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
this the format i need to get it to, i have manually done the first 2
| Structure 1 Pick ID | ADJ Structure 1 | ADJ Structure 2 | ADJ Structure 3 | ADJ Structure 4 | ADJ Structure 5 | ADJ Structure 6 |
| S1031855 | S1031856 | |||||
| S1031856 | S1031855 | S1031857 | ||||
| S1031857 | ||||||
| S1031858 | ||||||
| S1031859 | ||||||
| S1031860 | ||||||
| S1031861 | ||||||
| S1031862 | ||||||
| S1032012 | ||||||
| S1039241 | ||||||
| S1039242 | ||||||
| S1082299 | ||||||
| S1082300 | ||||||
| S1093398 | ||||||
| S1093411 | ||||||
| S1093412 | ||||||
| S1093414 | ||||||
| S1132631 | ||||||
| S1132632 | ||||||
| S1830436 | ||||||
| S2280348 | ||||||
| S1830240 | ||||||
| S1830478 | ||||||
| S1093399 | ||||||
| S1830230 | ||||||
| S1093413 | ||||||
| S1909383 | ||||||
| S2352540 | ||||||
| S1132634 |
<colgroup><col><col span="6"></colgroup><tbody>
</tbody>
