I hope I can clearly explain my question here. I am seeking to extract only specific entries from a data collection of approximately 1500 rows given a specific criteria (Cell H3). I've provided a screen shot of what I"m looking at with some Mock data to help the process. To summarize: I want to be able to automatically pull Project#, section, tech, MOB, & KM within all rows from "Data Dump Sheet" that begin with "CM-GF-20", and have them appear in "Past Runs Sheet". The code "CM-GF-20" is dependent on cell H3 from "Past Runs Sheet". I'm pretty sure it involves a sub-array formula of some sorts, but I don't seem to be able to get it to work, any and all help is appreciated!
Past Runs Sheet
<tbody>
</tbody>
Data Dump Sheet
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Past Runs Sheet
* | A | B | C | D | E | F | G | H | I | J | K |
1 | * | Line Specifications | * | * | Trap Sections | * | * | Corresponding Line Code | * | * | * |
2 | * | * | * | * | * | * | * | * | * | * | * |
3 | * | Line Number: | * | * | Launch: | Cromer | * | CM-GF-20 | * | * | * |
4 | * | Diameter: | 20 | * | Receive: | Gretna | * | * | * | * | * |
5 | * | * | * | * | * | * | * | * | * | * | * |
6 | * | * | * | * | * | * | * | * | * | * | * |
7 | Past Line Runs | * | * | * | * | * | * | * | * | * | * |
8 | * | * | * | * | * | * | * | * | * | * | * |
9 | Line Code | Project # | Section | Tech | MOB | KM | * | * | * | * | * |
10 | * | * | * | * | * | * | * | * | * | * | * |
11 | * | * | * | * | * | * | * | * | * | * | * |
12 | * | * | * | * | * | * | * | * | * | * | * |
13 | * | * | * | * | * | * | * | * | * | * | * |
14 | * | * | * | * | * | * | * | * | * | * | * |
<tbody>
</tbody>
Data Dump Sheet
* | A | B | C | D | E | F |
7 | * | * | * | * | * | * |
8 | * | * | * | * | * | * |
9 | Line Code | Project # | Section | Tech | MOB | KM |
10 | CM-GF-20 | 101211 | 20B | ISN | 19 | 283 |
11 | WS-NN-12 | 103639 | 12A | CD | 1 | 32.91 |
12 | WNR-EB-12 | 103639 | 12C | CLP | 20 | 1.06 |
13 | KB-QU-20 | 103639 | 20B | CLP | 18 | 352.63 |
14 | NN-WNR-20 | 103639 | 20F | CLP | 20 | 72.84 |
15 | YP-KB-24 | 103639 | 24A | CLP | 19 | 175.85 |
16 | YP-KB-24 | 103639 | 24A | ICR | 22 | 175.85 |
17 | YP-KB-24 | 103639 | 24A | SDY | 21 | 175.85 |
18 | CM-GF-16 | 106292 | 16C | CLP | 43 | 282.7 |
19 | CM-GF-16 | 106292 | 16C | ISN | 77 | 282.7 |
20 | KB-QU-20 | 106292 | 20D | SDY | 72 | 352.63 |
21 | EP-YP-24 | 106292 | 24A | CLP | 55 | 175.45 |
22 | EP-YP-24 | 106292 | 24B | CDX | 69 | 175.45 |
23 | EP-YP-24 | 106292 | 24B | ICR | 73 | 175.45 |
24 | EP-YP-24 | 106292 | 24B | SDY | 70 | 175.45 |
25 | KB-QU-24 | 106292 | 24C | ICR | 74 | 352.91 |
26 | KB-QU-24 | 106292 | 24C | SDY | 71 | 352.91 |
27 | EP-YP-24 | 106292 | 24F | CDX | 75 | 175.45 |
28 | KB-QU-24 | 106292 | 24G | CDX | 76 | 352.91 |
29 | QU-CM-34 | 106292 | 34C | CDX | 57 | 254.64 |
30 | YP-KB-34 | 106292 | 34E | WMX | 60 | 175.6 |
31 | NW-RE-30 | 107646 | 30A | MF3 | 17 | 194 |
32 | ML-CD-30 | 107646 | 30B | CLP | 18 | 206.04 |
33 | VG-PL-36 | 107649 | 36A | M3X | 6 | 46.56 |
34 | CR-CS-36 | 107649 | 36C | M3X | 7 | 71 |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Last edited: