Label All Fields Under a Header

[seguin85]

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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Station 5[/TD]
[TD]5/5/19[/TD]
[TD]6/5/19[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Build[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Station 6[/TD]
[TD]5/5/19[/TD]
[TD]6/5/19[/TD]
[TD]Build[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Station 7[/TD]
[TD]5/9/19[/TD]
[TD]5/12/19[/TD]
[TD]Build[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]System Build[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Station 6[/TD]
[TD]6/6/19[/TD]
[TD]7/1/19[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I only want column D to have labels between Build and System Build, everything else should be blank.

Thanks

 

[Fluff]

How about
=IF(AND(COUNTIF($A$1:$A1,"Build")=1,COUNTIF($A$2:$A2,"System Build")=0),"Build","")

 

[seguin85]

How about
=IF(AND(COUNTIF($A$1:$A1,"Build")=1,COUNTIF($A$2:$A2,"System Build")=0),"Build","")

I had to modify it a little to accommodate this happening more than 1x in the column, but the idea helped me out a lot!
=IF(COUNTIF($A$1:$A1,"Build")>COUNTIF($A$2:$A2,"System Build"),"Build","")

Thanks!

 

[Fluff]

Glad you sorted it & thanks for the feedback