Display consecutively repeated numbers in a consecutive

N

NiftyTrader

New Member
Joined
Jul 31, 2015
Messages
15
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.


[TABLE="width: 130"]
<!--StartFragment--> <colgroup><col width="65" style="width:65pt"> <col width="65" style="width:65pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 65"]Data[/TD]
[TD="class: xl63, width: 65"]Formula[/TD]
[/TR]
[TR]
[TD="class: xl63"]7[/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl63"]8[/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl63"]9[/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl63"]9[/TD]
[TD="class: xl63"]9[/TD]
[/TR]
[TR]
[TD="class: xl63"]9[/TD]
[TD="class: xl63"]9[/TD]
[/TR]
[TR]
[TD="class: xl63"]8[/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl63"]8[/TD]
[TD="class: xl63"]8[/TD]
[/TR]
[TR]
[TD="class: xl63"]10[/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl63"]10[/TD]
[TD="class: xl63"]10[/TD]
[/TR]
[TR]
[TD="class: xl63"]10[/TD]
[TD="class: xl63"]10[/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]
 
Last edited:

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Sort by date Sort by votes
Yes.. use below formula in cell B2 and drag down:-

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

Regards,
DILIPandey
 
Upvote 0
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.

[TABLE="width: 279"]
<tbody>[TR]
[TD]Data[/TD]
[TD]Formula[/TD]
[TD]Formula 2[/TD]
[TD]Formula 3[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD]<=A2[/TD]
[TD]>A2[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]IF(A1=A2,A2,"")[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD]6[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]9[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Not getting .. can you post your expected output with explanation ? thanks.


Regards,
DILIPandey
 
Upvote 0
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.

[TABLE="width: 682"]
<colgroup><col><col><col><col><col span="4"></colgroup><tbody>[TR]
[TD]Fluctuating Points[/TD]
[TD]Fast Moving Avg.[/TD]
[TD]Slow Moving Avg.[/TD]
[TD][/TD]
[TD]Repeated Value 1[/TD]
[TD]Repeated Value 2[/TD]
[TD]Repeated Value 3[/TD]
[TD]Repeated Value 3[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]9[/TD]
[TD]8[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]10[/TD]
[TD]8[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]10[/TD]
[TD]9[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]10[/TD]
[TD]9[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]13[/TD]
[TD]11[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]14[/TD]
[TD]12[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]17[/TD]
[TD]13[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]17[/TD]
[TD]14[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]17[/TD]
[TD]15[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]15[/TD]
[TD]15[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]12[/TD]
[TD]15[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]9[/TD]
[TD]14[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]7[/TD]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]6[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]6[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]17[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]6[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]9[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]11[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]11[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]10[/TD]
[TD]9[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]17[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
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
 
Upvote 0
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:


[TABLE="class: cms_table, width: 682"]
<tbody>[TR]
[/TR]
[TR]
[TD]Fluctuating Points[/TD]
[TD]Fast Moving Avg.[/TD]
[TD]Slow Moving Avg.[/TD]
[TD][/TD]
[TD]Repeated Value 1[/TD]
[TD]Repeated Value 2[/TD]
[TD]Repeated Value 3[/TD]
[TD]Repeated Value 3[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]9[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]10[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]10[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]10[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]13[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]14[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]17[/TD]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]17[/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]17[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]15[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]12[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]9[/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]7[/TD]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]6[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]6[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD]7[/TD]
[TD]10[/TD]
[TD]17[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]6[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]9[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]11[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]11[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]10[/TD]
[TD]9[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]17[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
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.


[TABLE="class: cms_table, width: 682"]
<tbody>[TR]
[/TR]
[TR]
[TD]Fluctuating Points[/TD]
[TD]Fast Moving Avg.[/TD]
[TD]Slow Moving Avg.[/TD]
[TD][/TD]
[TD]Repeated Value 1[/TD]
[TD]Repeated Value 2[/TD]
[TD]Repeated Value 3[/TD]
[TD]Repeated Value 3[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]9[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]10[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]10[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]10[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]13[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]14[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]17[/TD]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]17[/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]17[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]15[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]12[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]9[/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]7[/TD]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]6[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]6[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD]7[/TD]
[TD]10[/TD]
[TD]17[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]6[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD]10[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]9[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD]10[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]11[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]11[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]10[/TD]
[TD]9[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]17[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question Question
Compress consecutive numbers
Replies
9
Views
345
Fuji
F
I
  • Solved
Formula to count consecutive zeros at the end of a row
Replies
7
Views
276
Peter_SSs
Peter_SSs
R
  • Solved
Count of consecutive months same data value appears
Replies
1
Views
188
rhonllanders
R
D
  • Solved
Counting Consecutive Blanks
Replies
9
Views
596
felixstraube
F
T
  • Question Question
Running Average of last n row if sum is between a certain value
Replies
1
Views
58
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,223,275
Messages
6,171,121
Members
452,381
Latest member
Nova88

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top