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.

	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

 

[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