Hi, I am extracting data from a Microsoft Project file into Excel and need to write a formula to grab some data. It has a header called "Build" and then another header called "System Build". I want all the rows in between those to be labelled "Build".
ex.
<tbody>
</tbody>
I only want column D to have labels between Build and System Build, everything else should be blank.
Thanks
ex.
A | B | C | D | |
1 | Name | Start | End | Formula |
2 | Station 5 | 5/5/19 | 6/5/19 | |
3 | Build | |||
4 | Station 6 | 5/5/19 | 6/5/19 | Build |
5 | Station 7 | 5/9/19 | 5/12/19 | Build |
6 | System Build | |||
7 | Station 6 | 6/6/19 | 7/1/19 |
<tbody>
</tbody>
I only want column D to have labels between Build and System Build, everything else should be blank.
Thanks