Formulas for conditionally replicating values needed

Hello Sirs, Ma'ams,

Before I begin, I really need your solution to be a formula I just copy down because I have 10,000 rows of data!


50 sliding windows are used here. In the Excel attachment you will see what this means.
A1, A2 and A3 all contain values which are </> 50.
For A1: If there have been ≥10 values < 50 in the 50-period window and there are ≥25 values/cells remaining since the 10th value which was less than 50, replicate those 25 or more values/cells in cell A1 into cell B1.
Do the same for A2 and B2.
Do the same for A3 and B3.


Thank you very much for your time.

Coudl you add some numbers to the B1-B3 columns to see what you after?