Reverse Count continuous value

[skm_newsletter]

Hi All,

I need to reverse count continuous values. See example below
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]ActualYN[/TD]
[TD="width: 64"]Rcount[/TD]
[/TR]
[TR]
[TD]Down[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Down[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Up[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Up[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Up[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Down[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Down[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Up[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Down[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Down[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Down[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Up[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Up[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Up[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Up[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Down[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Up[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

Thanks,
Sanjay

 

[FormR]

Hi, you could try this:

Excel 2013
	A	B
1	ActualYN	Rcount
2	Down	2
3	Down	1
4	Up	3
5	Up	2
6	Up	1
7	Down	2
8	Down	1
9	Up	1
10	Down	3
11	Down	2
12	Down	1
13	Up	4
14	Up	3
15	Up	2
16	Up	1
17	Down	1
18	Up	1
Sheet1

Cell Formulas
Range	Formula
B2	=IF(A2=A3,B3+1,1)

 

[skm_newsletter]

Hi, you could try this:

Excel 2013

	A	B
ActualYN	Rcount
Down
Down
Up
Up
Up
Down
Down
Up
Down
Down
Down
Up
Up
Up
Up
Down
Up

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="bgcolor: #FFFF00, align: right"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]3[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]2[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]2[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]3[/TD]

[TD="align: center"]11[/TD]

[TD="align: right"]2[/TD]

[TD="align: center"]12[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]13[/TD]

[TD="align: right"]4[/TD]

[TD="align: center"]14[/TD]

[TD="align: right"]3[/TD]

[TD="align: center"]15[/TD]

[TD="align: right"]2[/TD]

[TD="align: center"]16[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]17[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]18[/TD]

[TD="align: right"]1[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B2[/TH]
[TD="align: left"]=IF(A2=A3,B3+1,1)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Hi,
This worked. Thank You.

Thanks,
Sanjay