Reverse Count continuous value

[skm_newsletter]

Hi All,

I need to reverse count continuous values. See example below

ActualYN	Rcount
Down	2
Down	1
Up	3
Up	2
Up	1
Down	2
Down	1
Up	1
Down	3
Down	2
Down	1
Up	4
Up	3
Up	2
Up	1
Down	1
Up	1

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

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
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

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B2 =IF(A2=A3,B3+1,1) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Hi,
This worked. Thank You.

Thanks,
Sanjay