Assuming A1:A20 contains "YES" in them.
Except A9 & A16 contain "NO".

B1:B20 is suppose to find only the "YES" value in A:A column.
Result should be in running sequence with no blank in between B:B column.
Which is to say B1:B18 return the "YES" TEXT but B19:B20 return "NO".

Need them to jump together in sequence in [B:B] when any rows in [A:A] is
invalid.

Q: Wondering can we made the cell B1 intelligent enough to find the first
"YES" for the range in [A:A], B2 to find the second "YES", B3 to find the
third "YES" and so forth.

Is there a formula to accomplished this?
Pls advise.
Thanks.