Number multiple same names

[SOLTEC]

Excel 2010
	A	B
1	Product ID	Name
2	1	Replacement Boot Laces
3		Replacement Boot Laces
4	2	Blousing Garters
5		Blousing Garters
6		Blousing Garters
7		Blousing Garters
8	3	GI Extreme Cold Weather Bunny Boots
9		GI Extreme Cold Weather Bunny Boots
10		GI Extreme Cold Weather Bunny Boots
11		GI Extreme Cold Weather Bunny Boots
12		GI Extreme Cold Weather Bunny Boots
13		GI Extreme Cold Weather Bunny Boots
14	4	Nylon Commando Wallet
15		Nylon Commando Wallet
16		Nylon Commando Wallet
17		Nylon Commando Wallet
18		Nylon Commando Wallet
19		Nylon Commando Wallet
20		Nylon Commando Wallet
21		Pepper Sprays Gel Sabre Red
22		Fire Master Fog Pepper Spray
23		Pepper Sprays Gel Sabre Red
24		Pepper Sprays Gel Sabre Red
25		Pepper Sprays Gel Sabre Red
26		Pepper Sprays Gel Sabre Red
27		Key Chain Pepper Spray
28		Pepper Sprays Gel Sabre Red
29		Cop Top Fog Cone Pepper Spray
30		Flip Top Stream Pepper Spray
31		Flip Top Cop Med Fog Cone Pepper Spray
32		Pepper Sprays Gel Sabre Red
33		Cop Top Stream Pepper Spray
34		Pepper Sprays Gel Sabre Red
35		Cop Top Fog Cone Pepper Spray
36		Flip Top Stream Pepper Spray
37		Flip Top Cop Med Fog Cone Pepper Spray
38		Cop Top Stream Pepper Spray
39		Pepper Sprays Gel Sabre Red
40		Pepper Sprays Gel Sabre Red
41		Police Magnum Sabre Red
42		Pepper Sprays Gel Sabre Red
Sheet1

Cell Formulas
Range	Formula
A1	Product ID
A2	1
A4	2
A8	3
A14	4
B1	Name
B2	Replacement Boot Laces
B3	Replacement Boot Laces
B4	Blousing Garters
B5	Blousing Garters
B6	Blousing Garters
B7	Blousing Garters
B8	GI Extreme Cold Weather Bunny Boots
B9	GI Extreme Cold Weather Bunny Boots
B10	GI Extreme Cold Weather Bunny Boots
B11	GI Extreme Cold Weather Bunny Boots
B12	GI Extreme Cold Weather Bunny Boots
B13	GI Extreme Cold Weather Bunny Boots
B14	Nylon Commando Wallet
B15	Nylon Commando Wallet
B16	Nylon Commando Wallet
B17	Nylon Commando Wallet
B18	Nylon Commando Wallet
B19	Nylon Commando Wallet
B20	Nylon Commando Wallet
B21	Pepper Sprays Gel Sabre Red
B22	Fire Master Fog Pepper Spray
B23	Pepper Sprays Gel Sabre Red
B24	Pepper Sprays Gel Sabre Red
B25	Pepper Sprays Gel Sabre Red
B26	Pepper Sprays Gel Sabre Red
B27	Key Chain Pepper Spray
B28	Pepper Sprays Gel Sabre Red
B29	Cop Top Fog Cone Pepper Spray
B30	Flip Top Stream Pepper Spray
B31	Flip Top Cop Med Fog Cone Pepper Spray
B32	Pepper Sprays Gel Sabre Red
B33	Cop Top Stream Pepper Spray
B34	Pepper Sprays Gel Sabre Red
B35	Cop Top Fog Cone Pepper Spray
B36	Flip Top Stream Pepper Spray
B37	Flip Top Cop Med Fog Cone Pepper Spray
B38	Cop Top Stream Pepper Spray
B39	Pepper Sprays Gel Sabre Red
B40	Pepper Sprays Gel Sabre Red
B41	Police Magnum Sabre Red
B42	Pepper Sprays Gel Sabre Red

I need a function or formula to number the first unique name for 7,000 items. As you can see the names are not always sequential. Thank you in advance for any and all assistance, it is greatly appreciated. See 1, 2, 3, 4 for example

 

[Jonmo1]

Your original post appears you want to have a number in only the first occurance of each identicle value.

That's what this formula does.

 

[Jonmo1]

If you want to have the unique numbers in ALL identicle cells..

Put the first number in A2 by hand.

Then in A3 and filled down
=IF(B3=B2,A2,A2+1)

 

[SOLTEC]

This isn't correct either as the Pepper Sprays Gel Sabre Red each have a different number. They should all be the same first number. (5 I believe)

Excel 2010
	A	B
1	ID	Name
2	1	Replacement Boot Laces
3	1	Replacement Boot Laces
4	2	Blousing Garters
5	2	Blousing Garters
6	2	Blousing Garters
7	2	Blousing Garters
8	3	GI Extreme Cold Weather Bunny Boots
9	3	GI Extreme Cold Weather Bunny Boots
10	3	GI Extreme Cold Weather Bunny Boots
11	3	GI Extreme Cold Weather Bunny Boots
12	3	GI Extreme Cold Weather Bunny Boots
13	3	GI Extreme Cold Weather Bunny Boots
14	4	Nylon Commando Wallet
15	4	Nylon Commando Wallet
16	4	Nylon Commando Wallet
17	4	Nylon Commando Wallet
18	4	Nylon Commando Wallet
19	4	Nylon Commando Wallet
20	4	Nylon Commando Wallet
21	5	Pepper Sprays Gel Sabre Red
22	6	Fire Master Fog Pepper Spray
23	7	Pepper Sprays Gel Sabre Red
24	7	Pepper Sprays Gel Sabre Red
25	7	Pepper Sprays Gel Sabre Red
26	7	Pepper Sprays Gel Sabre Red
27	8	Key Chain Pepper Spray
28	9	Pepper Sprays Gel Sabre Red
29	10	Cop Top Fog Cone Pepper Spray
30	11	Flip Top Stream Pepper Spray
31	12	Flip Top Cop Med Fog Cone Pepper Spray
32	13	Pepper Sprays Gel Sabre Red
33	14	Cop Top Stream Pepper Spray
34	15	Pepper Sprays Gel Sabre Red
35	16	Cop Top Fog Cone Pepper Spray
36	17	Flip Top Stream Pepper Spray
37	18	Flip Top Cop Med Fog Cone Pepper Spray
38	19	Cop Top Stream Pepper Spray
39	20	Pepper Sprays Gel Sabre Red
40	20	Pepper Sprays Gel Sabre Red
41	21	Police Magnum Sabre Red
42	22	Pepper Sprays Gel Sabre Red
Sheet1

Cell Formulas
Range	Formula
A2	=IF(COUNTIF($B$2:B2,B2)=1,COUNT($A$1:A1)+1,"")
A3	=IF(B3=B2,A2,A2+1)
A4	=IF(B4=B3,A3,A3+1)
A5	=IF(B5=B4,A4,A4+1)
A6	=IF(B6=B5,A5,A5+1)
A7	=IF(B7=B6,A6,A6+1)
A8	=IF(B8=B7,A7,A7+1)
A9	=IF(B9=B8,A8,A8+1)
A10	=IF(B10=B9,A9,A9+1)
A11	=IF(B11=B10,A10,A10+1)
A12	=IF(B12=B11,A11,A11+1)
A13	=IF(B13=B12,A12,A12+1)
A14	=IF(B14=B13,A13,A13+1)
A15	=IF(B15=B14,A14,A14+1)
A16	=IF(B16=B15,A15,A15+1)
A17	=IF(B17=B16,A16,A16+1)
A18	=IF(B18=B17,A17,A17+1)
A19	=IF(B19=B18,A18,A18+1)
A20	=IF(B20=B19,A19,A19+1)
A21	=IF(B21=B20,A20,A20+1)
A22	=IF(B22=B21,A21,A21+1)
A23	=IF(B23=B22,A22,A22+1)
A24	=IF(B24=B23,A23,A23+1)
A25	=IF(B25=B24,A24,A24+1)
A26	=IF(B26=B25,A25,A25+1)
A27	=IF(B27=B26,A26,A26+1)
A28	=IF(B28=B27,A27,A27+1)
A29	=IF(B29=B28,A28,A28+1)
A30	=IF(B30=B29,A29,A29+1)
A31	=IF(B31=B30,A30,A30+1)
A32	=IF(B32=B31,A31,A31+1)
A33	=IF(B33=B32,A32,A32+1)
A34	=IF(B34=B33,A33,A33+1)
A35	=IF(B35=B34,A34,A34+1)
A36	=IF(B36=B35,A35,A35+1)
A37	=IF(B37=B36,A36,A36+1)
A38	=IF(B38=B37,A37,A37+1)
A39	=IF(B39=B38,A38,A38+1)
A40	=IF(B40=B39,A39,A39+1)
A41	=IF(B41=B40,A40,A40+1)
A42	=IF(B42=B41,A41,A41+1)

 

[Jonmo1]

OK, fair enough.
It seemed at first glance that your data was sorted so that all similar values were grouped together...
I see now that's not the case..

Try this in A2 and filled down
=IF(ISNA(MATCH(B2,B$1:B1,0)),MAX(A$1:A1)+1,INDEX(A$1:A1,MATCH(B2,B$1:B1,0)))

 

[SOLTEC]

Thank you Thank you a thousand times Thank YOU very much.