Return prior values that repeat at least 3 times consecutively.

[NiftyTrader]

I have a fluctuating data in column A:A, a Fast MA in column B:B, Slow MA in C:C.



I'm going to start with the first formula to compute in Column E:E, which
1. needs to display a prior value repeated at least 3 times consecutively (not in order of occurrence just needs to be in the formula like $B$3:C100 that meets additional criteria)
2. value in both columns that must be less than or equal to the current fluctuating value in A:A, starting with 5.

Column D:D formula should be the next >=3x consecutively repeated number less than the value of E:E equation of the same same.

Column F:F formula should be the >=3x consecutively repeated number that is greater than (not equal to) the current fluctuating number in column A:A of the same row.

Column G:G formula should be the next >=3x consecutively repeated number greater than the value in column F:F of the same row.

I put the results of the values for each Repeated Values that I want for each formula to equate

Fluctuating Points	Fast Moving Avg.	Slow Moving Avg.		Repeated Value 1	Repeated Value 2	Repeated Value 3	Repeated Value 3
5
6
7	6
7	7
7	7
8	7
9	8
11	9	8
10	10	8
10	10	9
11	10	9
10	10	10
17	13	11
16	14	12
18	17	13
18	17	14
16	17	15
11	15	15
10	12	15
7	9	14
5	7	13				6	7
6	6	11			6	7	8
8	6	10		7	8	10	15
5	6	9				6	7
10	8	8		8	10	15	17
11	9	8		8	10	15	17
11	11	8		8	10	15	17
11	11	8		8	10	15	17
9	10	9		7	8	15	17

<tbody>
</tbody>

 

[NiftyTrader]

Any ideas will help if it can be done. Thanks!