Count unique numbers

[el c]

Hi,

I am trying to count the numbers from the first column (ItemCode). Some of those numbers are duplicated so the duplicated ones that are the same need to have the same number in the column "Numbers". Meaning for exapmle 31112802 which is duplicated, has a number of 2 and the next 31112802 that appers on the next rows needs to have the number 2. How can i do this without changing the range of the rows?

Inventories2.xlsx
	A	B	C
1	Item Code		Numbers
2	25708011		1
3	31112802	Duplicate	2
4	25712801		3
5	25708010		4
6	25715502		5
7	25712803	Duplicate	6
8	25712103	Duplicate	7
9	31112142	Duplicate	8
10	29812022	Duplicate	9
11	1030083	Duplicate	10
12	31112144	Duplicate	11
13	31112343	Duplicate	12
14	25712104	Duplicate	13
15	41815001		14
16	31112141	Duplicate	15
17	31112344		16
18	31112143	Duplicate	17
19	31112342		18
20	29812023	Duplicate	19
21	31112341	Duplicate	20
22	25715005	Duplicate	21
23	23636002		22
24	2801101		23
25	2402029		24
26	41815005		25
27	41815002		26
28	41815150		27
29	16423003	Duplicate	28
30	15711223		29
31	15711027		30
32	25711522	Duplicate	31
33	15711011		32
34	25711020	Duplicate	33
35	25712071		34
36	25704003	Duplicate	35
37	19104005		36
38	23636001	Duplicate	37
39	16823001		38
40	1030094	Duplicate	39
41	1030094	Duplicate	39
42	15505080	Duplicate	40
43	15505081		41
44	7102016		42
45	25711050		43
46	102100		44
47	37623004	Duplicate	45
48	36766050		46
49	41815030		47
50	45316140	Duplicate	48
51	25710831	Duplicate	49
52	25710532		50
53	25710831	Duplicate	51
54	25710632	Duplicate	52
55	1030017		53
56	25715001		54
57	32416003		55
58	41815032	Duplicate	56
59	46605001	Duplicate	57
60	23636001	Duplicate	58
61	1414601		59
62	1414712		60
63	39808002	Duplicate	61
64	25730001		62
65	25711521	Duplicate	63
66	33130010	Duplicate	64
67	7923001		65
68	1006006		66
69	25715011		67
70	25715002	Duplicate	68
71	25715005	Duplicate	69
Φύλλο1

Cell Formulas
Range	Formula
B2:B71	B2	=IF(COUNTIF($A$2:$A$400, $A2)>1, "Duplicate", "")
C3:C71	C3	=IF(A3=A2,C2,C2+1)

 

[Peter_SSs]

Like this?

20 03 28.xlsm
	A	B
1	Item Code	Numbers
2	14	1
3	6	2
4	18	3
5	6	2
6	9	4
7	9	4
8	17	5
9	18	3
10	15	6
11	14	1
12	18	3
13	6	2
14	1	7
15	18	3
16	17	5
17	6	2
18	6	2
19	12	8
20	2	9
21	6	2
22	12	8
23	4	10
24	17	5
25	14	1
26	6	2
27	6	2
28	9	4
29	9	4
30	20	11
31	5	12
32	16	13
Numbers

Cell Formulas
Range	Formula
B2:B32	B2	=IFERROR(VLOOKUP(A2,A$1:B1,2,0),MAX(B$1:B1)+1)

 

[el c]

Like this?

20 03 28.xlsm
	A	B
1	Item Code	Numbers
2	14	1
3	6	2
4	18	3
5	6	2
6	9	4
7	9	4
8	17	5
9	18	3
10	15	6
11	14	1
12	18	3
13	6	2
14	1	7
15	18	3
16	17	5
17	6	2
18	6	2
19	12	8
20	2	9
21	6	2
22	12	8
23	4	10
24	17	5
25	14	1
26	6	2
27	6	2
28	9	4
29	9	4
30	20	11
31	5	12
32	16	13
Numbers

Cell Formulas
Range	Formula
B2:B32	B2	=IFERROR(VLOOKUP(A2,A$1:B1,2,0),MAX(B$1:B1)+1)

Yes thank you for your fast reply.

 

[Peter_SSs]

Yes thank you for your fast reply.

You're welcome. Thanks for the follow-up.

 

[el c]

You're welcome. Thanks for the follow-up.

Do you know perhaps how i can add those numbers next to the new itemcode that i have? Like this example:

Inventories2.xlsx
	I	J	K	L	M
1	Item Code	Numbers		New itemcode
2	444	1		555	2
3	555	2		333
4	333	3		555
5	444	1		785
6	785	4		444
ItemCode to Numbers

 

[Fluff]

How about

+Fluff.xlsm
	A	B	C	D	E
1	Item Code	Numbers		New itemcode
2	444	1		555	2
3	555	2		333	3
4	333	3		555	2
5	444	1		785	4
6	785	4		444	1
Master

Cell Formulas
Range	Formula
E2:E6	E2	=XLOOKUP(D2,$A$2:$A$6,$B$2:$B$6,"",0)

 

[el c]

How about

+Fluff.xlsm
	A	B	C	D	E
1	Item Code	Numbers		New itemcode
2	444	1		555	2
3	555	2		333	3
4	333	3		555	2
5	444	1		785	4
6	785	4		444	1
Master

Cell Formulas
Range	Formula
E2:E6	E2	=XLOOKUP(D2,$A$2:$A$6,$B$2:$B$6,"",0)

Yes but when i copy paste it to excel it shows me this:

Inventories2.xlsx
	A	B	C	D	E
1	Item Code	Numbers		New itemcode
2	444	1		555	#NAME?
3	555	2		333	#NAME?
4	333	3		555	#NAME?
5	444	1		785	#NAME?
6	785	4		444	#NAME?
Sheet1

Cell Formulas
Range	Formula
E2:E6	E2	=XLOOKUP(D2,$A$2:$A$6,$B$2:$B$6,"",0)

 

[Fluff]

In that case how about
=VLOOKUP(D2,$A$2:$B$6,2,0)

 

[el c]

In that case how about
=VLOOKUP(D2,$A$2:$B$6,2,0)

Yes thank you

 

[Fluff]

You're welcome & thanks for the feedback