Special counting needed..

[omairhe]

Hey,

Hope you all doing good. I'm in need of 2 formulas that goes in column C and column D.. or perhaps a code that could give me the results of column C and column D.

Column Column Column Column
A B C D

a	ap	1	1
a	ap	1	1
a	as	1	2
a	as	1	2
a	as	1	2
b	bi	2	1
b	bo	2	2
b	bo	2	2
b	br	2	3
b	br	2	3
b	br	2	3
b	bu	2	4
b	by	2	5
c	ca	3	1
c	ca	3	1

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

In above data column C is being calculated from column A's values only. Interestingly column D does the same with column B's values but every time a new value is seen in column A's target.row then the counting resets and starts from 1 again.


If someone could help me out here I'd appreciate it.

Thanks.

 

[Eric W]

Start with 1 in C1 and D1. Then put the C2 and D2 formulas in and drag down.

	A	B	C	D
1	a	ap	1	1
2	a	ap	1	1
3	a	as	1	2
4	a	as	1	2
5	a	as	1	2
6	b	bi	2	1
7	b	bo	2	2
8	b	bo	2	2
9	b	br	2	3
10	b	br	2	3
11	b	br	2	3
12	b	bu	2	4
13	b	by	2	5
14	c	ca	3	1
15	c	ca	3	1

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

Sheet10​

Worksheet Formulas Cell Formula C2 =IF(A1=A2,C1,C1+1) D2 =IF(C1<>C2,1,IF(B1=B2,D1,D1+1)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Hope this helps.

 

[omairhe]

Yay Working...

Thx ERIC.

 

[Eric W]

You're welcome.

Have a Happy New Year.