Add numbers, based on groups and every 2

[FatWhale38]

Hi guys

I was hoping someone could help me with a formula.

I have groups in column A, and need to pair them in column B. Each group will have different numbers of pairings, but every pair must have 2, and must be incremental.

The following is the end result I'm looking at.

Groups	Numbers
A	1
A	1
B	1
B	1
A	2
A	2
A	3
A	3
C	1
C	1
B	2
B	2

At the moment, I'm filtering, and then typing it in manually - cannot rearrange the rows due to another restriction

I tried to divide, then realised the numbers didn't quite make sense.

Really hope someone can come up with a solution for me.

Thanks!

 

[Snakehips]

@FatWhale38
Maybe like...

Book1
	A	B
1	Groups	Pairing
2	A	1
3	A	1
4	B	1
5	B	1
6	A	2
7	A	2
8	A	3
9	A	3
10	B	2
11	B	2
12	C	1
13	C	1
Sheet1

Cell Formulas
Range	Formula
B2:B13	B2	=ROUNDUP(COUNTIF(A$2:A2,A2)/2,0)

Hope that helps

 

[Peter_SSs]

Similarly

20 04 05.xlsm
	A	B
1	Groups	Pairing
2	A	1
3	A	1
4	B	1
5	B	1
6	A	2
7	A	2
8	A	3
9	A	3
10	B	2
11	B	2
12	C	1
13	C	1
Pairs

Cell Formulas
Range	Formula
B2:B13	B2	=INT(COUNTIF(A$1:A1,A2)/2)+1