Number multiple same names

[SOLTEC]

ID Name
1 Replacement Boot Laces
Replacement Boot Laces
2 Blousing Garters
Blousing Garters
Blousing Garters
Blousing Garters
3 GI Extreme Cold Weather Bunny Boots
GI Extreme Cold Weather Bunny Boots
GI Extreme Cold Weather Bunny Boots
GI Extreme Cold Weather Bunny Boots
GI Extreme Cold Weather Bunny Boots
GI Extreme Cold Weather Bunny Boots
4 Nylon Commando Wallet
Nylon Commando Wallet
Nylon Commando Wallet
Nylon Commando Wallet
Nylon Commando Wallet
Nylon Commando Wallet
Nylon Commando Wallet
Pepper Sprays Gel Sabre Red
Fire Master Fog Pepper Spray
Pepper Sprays Gel Sabre Red
Pepper Sprays Gel Sabre Red
Pepper Sprays Gel Sabre Red
Pepper Sprays Gel Sabre Red
Key Chain Pepper Spray
Pepper Sprays Gel Sabre Red
Cop Top Fog Cone Pepper Spray
Flip Top Stream Pepper Spray
Flip Top Cop Med Fog Cone Pepper Spray
Pepper Sprays Gel Sabre Red
Cop Top Stream Pepper Spray
Pepper Sprays Gel Sabre Red
Cop Top Fog Cone Pepper Spray
Flip Top Stream Pepper Spray
Flip Top Cop Med Fog Cone Pepper Spray
Cop Top Stream Pepper Spray
Pepper Sprays Gel Sabre Red
Pepper Sprays Gel Sabre Red
Police Magnum Sabre Red
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

 

[pennep]

One of the basic procedure to get what you want to achieve is:
> Sort the sheet by the name of the items.
> Then in column B (i.e. number), enter 1 in cell corresponding to the first item and use this formula, =IF(A3<>A2,B2+1,B2), in column B3 and copy it down.
> Concatenate column B and Column A using this formula =IF(A2<>A1,B2&" "&A2,A2) in column C2
This will produce result as:

[TABLE="width: 593"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]item[/TD]
[TD]number[/TD]
[TD] concatenation [/TD]
[/TR]
[TR]
[TD]Blousing Garters[/TD]
[TD]1[/TD]
[TD]1 Blousing Garters [/TD]
[/TR]
[TR]
[TD]Blousing Garters[/TD]
[TD]1[/TD]
[TD]Blousing Garters[/TD]
[/TR]
[TR]
[TD]Blousing Garters[/TD]
[TD]1[/TD]
[TD]Blousing Garters[/TD]
[/TR]
[TR]
[TD]Blousing Garters[/TD]
[TD]1[/TD]
[TD]Blousing Garters[/TD]
[/TR]
[TR]
[TD]Cop Top Fog Cone Pepper Spray[/TD]
[TD]2[/TD]
[TD]2 Cop Top Fog Cone Pepper Spray[/TD]
[/TR]
[TR]
[TD]Cop Top Fog Cone Pepper Spray[/TD]
[TD]2[/TD]
[TD]Cop Top Fog Cone Pepper Spray[/TD]
[/TR]
[TR]
[TD]Cop Top Stream Pepper Spray[/TD]
[TD]3[/TD]
[TD]3 Cop Top Stream Pepper Spray[/TD]
[/TR]
[TR]
[TD]Cop Top Stream Pepper Spray[/TD]
[TD]3[/TD]
[TD]Cop Top Stream Pepper Spray[/TD]
[/TR]
[TR]
[TD]Fire Master Fog Pepper Spray[/TD]
[TD]4[/TD]
[TD]4 Fire Master Fog Pepper Spray[/TD]
[/TR]
[TR]
[TD]Flip Top Cop Med Fog Cone Pepper Spray[/TD]
[TD]5[/TD]
[TD]5 Flip Top Cop Med Fog Cone Pepper Spray[/TD]
[/TR]
[TR]
[TD]Flip Top Cop Med Fog Cone Pepper Spray[/TD]
[TD]5[/TD]
[TD]Flip Top Cop Med Fog Cone Pepper Spray[/TD]
[/TR]
[TR]
[TD]Flip Top Stream Pepper Spray[/TD]
[TD]6[/TD]
[TD]6 Flip Top Stream Pepper Spray[/TD]
[/TR]
[TR]
[TD]Flip Top Stream Pepper Spray[/TD]
[TD]6[/TD]
[TD]Flip Top Stream Pepper Spray[/TD]
[/TR]
[TR]
[TD]GI Extreme Cold Weather Bunny Boots[/TD]
[TD]7[/TD]
[TD]7 GI Extreme Cold Weather Bunny Boots[/TD]
[/TR]
[TR]
[TD]GI Extreme Cold Weather Bunny Boots[/TD]
[TD]7[/TD]
[TD]GI Extreme Cold Weather Bunny Boots[/TD]
[/TR]
[TR]
[TD]GI Extreme Cold Weather Bunny Boots[/TD]
[TD]7[/TD]
[TD]GI Extreme Cold Weather Bunny Boots[/TD]
[/TR]
[TR]
[TD]GI Extreme Cold Weather Bunny Boots[/TD]
[TD]7[/TD]
[TD]GI Extreme Cold Weather Bunny Boots[/TD]
[/TR]
[TR]
[TD]GI Extreme Cold Weather Bunny Boots[/TD]
[TD]7[/TD]
[TD]GI Extreme Cold Weather Bunny Boots[/TD]
[/TR]
[TR]
[TD]GI Extreme Cold Weather Bunny Boots[/TD]
[TD]7[/TD]
[TD]GI Extreme Cold Weather Bunny Boots[/TD]
[/TR]
[TR]
[TD]Key Chain Pepper Spray[/TD]
[TD]8[/TD]
[TD]8 Key Chain Pepper Spray[/TD]
[/TR]
[TR]
[TD]Nylon Commando Wallet[/TD]
[TD]9[/TD]
[TD]9 Nylon Commando Wallet[/TD]
[/TR]
[TR]
[TD]Nylon Commando Wallet[/TD]
[TD]9[/TD]
[TD]Nylon Commando Wallet[/TD]
[/TR]
[TR]
[TD]Nylon Commando Wallet[/TD]
[TD]9[/TD]
[TD]Nylon Commando Wallet[/TD]
[/TR]
[TR]
[TD]Nylon Commando Wallet[/TD]
[TD]9[/TD]
[TD]Nylon Commando Wallet[/TD]
[/TR]
[TR]
[TD]Nylon Commando Wallet[/TD]
[TD]9[/TD]
[TD]Nylon Commando Wallet[/TD]
[/TR]
[TR]
[TD]Nylon Commando Wallet[/TD]
[TD]9[/TD]
[TD]Nylon Commando Wallet[/TD]
[/TR]
[TR]
[TD]Nylon Commando Wallet[/TD]
[TD]9[/TD]
[TD]Nylon Commando Wallet[/TD]
[/TR]
[TR]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[TD]10[/TD]
[TD]10 Pepper Sprays Gel Sabre Red[/TD]
[/TR]
[TR]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[TD]10[/TD]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[/TR]
[TR]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[TD]10[/TD]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[/TR]
[TR]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[TD]10[/TD]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[/TR]
[TR]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[TD]10[/TD]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[/TR]
[TR]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[TD]10[/TD]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[/TR]
[TR]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[TD]10[/TD]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[/TR]
[TR]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[TD]10[/TD]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[/TR]
[TR]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[TD]10[/TD]
[TD]Pepper Sprays Gel Sabre Red[/TD]
[/TR]
</tbody>[/TABLE]

Hope it helps!

 

[SOLTEC]

Excel 2010
	A	B
1	Product 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	5	Pepper Sprays Gel Sabre Red
24	5	Pepper Sprays Gel Sabre Red
25	5	Pepper Sprays Gel Sabre Red
26	5	Pepper Sprays Gel Sabre Red
27	7	Key Chain Pepper Spray
28	5	Pepper Sprays Gel Sabre Red
29	8	Cop Top Fog Cone Pepper Spray
30	9	Flip Top Stream Pepper Spray
31	10	Flip Top Cop Med Fog Cone Pepper Spray
32	5	Pepper Sprays Gel Sabre Red
33	11	Cop Top Stream Pepper Spray
34	5	Pepper Sprays Gel Sabre Red
35	8	Cop Top Fog Cone Pepper Spray
36	9	Flip Top Stream Pepper Spray
37	10	Flip Top Cop Med Fog Cone Pepper Spray
38	11	Cop Top Stream Pepper Spray
39	5	Pepper Sprays Gel Sabre Red
40	5	Pepper Sprays Gel Sabre Red
41	12	Police Magnum Sabre Red
42	5	Pepper Sprays Gel Sabre Red
43	13	Police Magnum Advanced 3 in 1 Formaula Sabre Red
44	5	Pepper Sprays Gel Sabre Red
45	14	Tactical Baton Sabre Red
46	15	Pepper Spray Refill Sabre Red
47	16	Sabre Red Blue Face Pepper Spray
48	5	Pepper Sprays Gel Sabre Red
49	5	Pepper Sprays Gel Sabre Red
50	5	Pepper Sprays Gel Sabre Red
51	5	Pepper Sprays Gel Sabre Red
52	5	Pepper Sprays Gel Sabre Red
53	17	Sabre Red Spitfire Pepper Spray
54	18	Sabre Home Away Protection Kit
55	19	Sabre Red Pepper Self Defense Spray
56	19	Sabre Red Pepper Self Defense Spray
57	20	1 5 Million Volt Stun Gun
58	21	650K Volt Stun Gun
59	22	Sabre 600K Volt Stun Gun
60	22	Sabre 600K Volt Stun Gun
61	23	Sabre 800K Volt Stun Gun
62	23	Sabre 800K Volt Stun Gun
63	24	Baton Stun Gun
64	25	UZI Metal Detector
65	26	Stun Gun Pen
66	27	Personal Protection Combo Pack
67	28	UZI 1 5 Million Volt Stun Gun
68	29	12 Million Volt Stunner Stun Gun
Sheet1

Cell Formulas
Range	Formula
A1	Product ID
A2	1
A3	1
A4	2
A5	2
A6	2
A7	2
A8	3
A9	3
A10	3
A11	3
A12	3
A13	3
A14	4
A15	4
A16	4
A17	4
A18	4
A19	4
A20	4
A21	5
A22	6
A23	5
A24	5
A25	5
A26	5
A27	7
A28	5
A29	8
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

Here is the spreadsheet that I have manually started numbering.