Display consecutively repeated numbers in a consecutive

[NiftyTrader]

Is there a way I can display consecutively repeated values from a column with column A being my data and column B my formula? Thanks.

Data	Formula
7
8
9
9	9
9	9
8
8	8
10
10	10
10	10

<!--StartFragment--> <colgroup><col width="65" style="width:65pt"> <col width="65" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

 

[DILIPandey]

Yes.. use below formula in cell B2 and drag down:-

=IF(A1=A2,A2,"")

Regards,
DILIPandey

 

[NiftyTrader]

Thanks. Is there a way I can get the repeated values that are less than and greater than the data value of the same row? I saw a formula that uses INDEX and MATCh function to display these numbers.

Data	Formula	Formula 2	Formula 3
7		<=A2	>A2
8	IF(A1=A2,A2,"")
9
9	9
9	9
8
8	8
10
10	10
10	10
9
9	9	9	10
8		8	9
7			8
6			8
6	6	6	8
6	6	6	8
7		6	8
7	7	7	8
8		8	9

<tbody>
</tbody>

 

[DILIPandey]

Not getting .. can you post your expected output with explanation ? thanks.


Regards,
DILIPandey

 

[NiftyTrader]

I want to make a real time support and resistance levels based off of the fluctuating data points. Repeated Value 2 should be less than or equal to the corresponding fluctuating data point. Repeated Value 1 is less than Repeated Value 2. repeated Value 3 is greater than the current fluctuating Data Point. Repeated Value 4 is greater than Repeated Value 3. I would like the formulas to draw from all prior repeated values so that I can see the levels throughout if the fluctuating points move back to prior ranges.

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	17
5	6	9				6	7
10	8	8		8	10	17
11	9	8		8	10	17
11	11	8		8	10	17
11	11	8		8	10	17
9	10	9		7	8	10	17

<colgroup><col><col><col><col><col span="4"></colgroup><tbody>
</tbody>

 

[DILIPandey]

Okay... first 3 columns would be available with you and rest of the columns i.e., Repeated value 1,2,3,4 you wish to obtain using formulas .. correct ?
If that is the case, can you explain how you have calculated the values in these columns .. let say how you got 7 in first repeated column ?


Regards,
DILIPandey

 

[NiftyTrader]

The repeated values are support and resistance levels of the fluctuating points in column A. Repeated value 2 is the first repeated value less than or equal to the fluctuation point. So that 7 is the first support level below the current fluctuating point. I wrote the data wrong. This is the right data:

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	10	17
5	6	9				6	7
10	8	8		8	10	17
11	9	8		8	10	17
11	11	8		8	10	17
11	11	8		8	10	17
9	10	9		7	8	10	17

<tbody>
</tbody>

 

[NiftyTrader]

Ignore the prior cells. Sorry for the confusion. The repeated values are support and resistance levels of the fluctuating points in column A. Repeated value 2 is the first repeated value less than or equal to the fluctuation point. So that 7 is the first support level below the current fluctuating point. I wrote the data wrong above. So if the fluctuating point is 8, and there were prior repeated values (3 times consecutively) within the moving averages of 7, 10, 15 and 17. So 7 is the only support level for a current fluctuating value of 8. So 10, 15 and 17 are the resistance levels in order for the fluctuating point of 8. This should be the data you should use for the formulas for the all 4 repeated values columns. Thanks.

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	10	17
5	6	9				6	7
10	8	8			10	17
11	9	8			10	17
11	11	8		8	10	17
11	11	8		8	10	17
9	10	9		7	8	10	17

<tbody>
</tbody>