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

 

[Scott Huish]

In B2:
=IF(COUNTIF($C$2:C2,C2)=1,COUNT($B$1:B1)+1,"")

Copy down.

 

[SOLTEC]

When I copy the formula in B2 and run it down it just deletes all my entries.

 

[Scott Huish]

Sorry, in A2:
=IF(COUNTIF($B$2:B2,B2)=1,COUNT($A$1:A1)+1,"")

Copy down.

 

[SOLTEC]

Excel 2010
	A	B
1	Product ID	Name
2	1	Replacement Boot Laces
3	1	Replacement Boot Laces
4		Blousing Garters
5	3	Blousing Garters
6		Blousing Garters
7		Blousing Garters
8		GI Extreme Cold Weather Bunny Boots
9	4	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		Nylon Commando Wallet
15	5	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	6	Fire Master Fog Pepper Spray
23	6	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	8	Pepper Sprays Gel Sabre Red
29		Cop Top Fog Cone Pepper Spray
30	9	Flip Top Stream Pepper Spray
31	9	Flip Top Cop Med Fog Cone Pepper Spray
32	10	Pepper Sprays Gel Sabre Red
33		Cop Top Stream Pepper Spray
34	12	Pepper Sprays Gel Sabre Red
35		Cop Top Fog Cone Pepper Spray
36		Flip Top Stream Pepper Spray
Sheet1

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

Strange behavior and I need all the same text with the same number please.

 

[Scott Huish]

How did you even get it to take A0 as a reference?

Your first formula is wrong however, it should be:
=IF(COUNTIF($B$2:B2,B2)=1,COUNT($A$1:A1)+1,"")

Copy down.

 

[Jonmo1]

How did you even get it to take A0 as a reference?

I wondered about that to.

It turns out the A0 translates to #NAME? error

So it goes like
=IF(COUNTIF($B1:B$2,B1)=1,COUNT($A$1:A0)+1,"")
=IF(COUNTIF($B1:B$2,B1)=1,COUNT($A$1:#NAME?)+1,"")
=IF(COUNTIF($B1:B$2,B1)=1,COUNT(#NAME?)+1,"")
=IF(COUNTIF($B1:B$2,B1)=1,0+1,"")
=IF(COUNTIF($B1:B$2,B1)=1,1,"")

You can even put
=A0
directly into a cell and it will allow it, but returns #NAME?

 

[SOLTEC]

Thank you, when I put the formula in the A1 position cell I get the results almost like I need. I need the numbers to fill in all IDENTICAL B cell

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		Pepper Sprays Gel Sabre Red
24		Pepper Sprays Gel Sabre Red
25		Pepper Sprays Gel Sabre Red
26		Pepper Sprays Gel Sabre Red
27	7	Key Chain Pepper Spray
28		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		Pepper Sprays Gel Sabre Red
33	11	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	12	Police Magnum Sabre Red
Sheet1

Cell Formulas
Range	Formula
A1	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
A27	7
A29	8
A30	9
A31	10
A33	11
A41	12
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

 

[Jonmo1]

Thank you, when I put the formula in the A1 position cell I get the results almost like I need. I need the numbers to fill in all IDENTICAL B cell

The formula goes in A2

IN A2, put
=IF(COUNTIF($B$2:B2,B2)=1,COUNT($A$1:A1)+1,"")
Then filled down.

 

[SOLTEC]

This doesn't give me all the same number for Identical strings in B Column.