Sort a column for matching items and add an increment number in the adjacent column.

[cguru]

I am new to VBA and I'm not to sure how to do this. any help would really be appreciated.

Sort thru the "Same Issues" column and when you find Matching cells, mark in "Matching" column a number that is incremented by one for the next matching issue.

See the sheet below the results in Column D that I am expecting.

Function​	Same Issues	Matching
Cat	Brown in color
Dog	He is bitting you
Dog	He is licking you
Mouse	He is eating chese
Mouse	He is running away
Chicken	Laying eggs	1
Chicken	Laying eggs	1
Lion	Roaring
Rabbit	He has green eyes
Rabbit	White Rabbit	2
Rabbit	White Rabbit	2
Rabbit	Blue Rabbit
Rabbit	He is small	3
Rabbit	He is small	3
Rabbit	Run fast run
Rabbit	Run slow
Rabbit	Such a little one
Rabbit	He is sitting	4
Rabbit	He is sitting	4
Rabbit	He is sitting	4
Rabbit	He jumps fast.	5
Rabbit	He jumps fast.	5
Rabbit	He jumps fast.	5
Rabbit	He jumps fast.	5
Rabbit	He jumps fast.	5
Rabbit	He jumps fast.	5
Rabbit	He jumps fast.	5
Rabbit	He is 123
Rabbit	Find him in bushes
Tiger	He is big
Tiger	In the water	6
Tiger	In the water	6
Wolf	Fat as a pig
Deer	Long face
Deer	where is he
Deer	Must be a fawn
Deer	Find his atllers	7
Deer	Find his atllers	7
Deer	Find his atllers	7
Deer	Smal deer
Deer	Little deer
Deer	hungry deer	8
Deer	hungry deer	8
Deer	Unable to Upload	9
Deer	Unable to Upload	9
Deer	Unable to Upload	9
Deer	Unable to Upload	9
Deer	Unable to Upload	9
Deer	Unable to Upload	9
Monkey	Big monkey	10
Monkey	Big monkey	10
Monkey	Little Monkey
Monkey	Fat Monkey

 

[lrobbo314]

You can do this with a formula.

Book1
	A	B	C	D
1	Function	Same Issues	Matching	FX
2	Cat	Brown in color
3	Dog	He is bitting you
4	Dog	He is licking you
5	Mouse	He is eating chese
6	Mouse	He is running away
7	Chicken	Laying eggs	1	1
8	Chicken	Laying eggs	1	1
9	Lion	Roaring
10	Rabbit	He has green eyes
11	Rabbit	White Rabbit	2	2
12	Rabbit	White Rabbit	2	2
13	Rabbit	Blue Rabbit
14	Rabbit	He is small	3	3
15	Rabbit	He is small	3	3
16	Rabbit	Run fast run
17	Rabbit	Run slow
18	Rabbit	Such a little one
19	Rabbit	He is sitting	4	4
20	Rabbit	He is sitting	4	4
21	Rabbit	He is sitting	4	4
22	Rabbit	He jumps fast.	5	5
23	Rabbit	He jumps fast.	5	5
24	Rabbit	He jumps fast.	5	5
25	Rabbit	He jumps fast.	5	5
26	Rabbit	He jumps fast.	5	5
27	Rabbit	He jumps fast.	5	5
28	Rabbit	He jumps fast.	5	5
29	Rabbit	He is 123
30	Rabbit	Find him in bushes
31	Tiger	He is big
32	Tiger	In the water	6	6
33	Tiger	In the water	6	6
34	Wolf	Fat as a pig
35	Deer	Long face
36	Deer	where is he
37	Deer	Must be a fawn
38	Deer	Find his atllers	7	7
39	Deer	Find his atllers	7	7
40	Deer	Find his atllers	7	7
41	Deer	Smal deer
42	Deer	Little deer
43	Deer	hungry deer	8	8
44	Deer	hungry deer	8	8
45	Deer	Unable to Upload	9	9
46	Deer	Unable to Upload	9	9
47	Deer	Unable to Upload	9	9
48	Deer	Unable to Upload	9	9
49	Deer	Unable to Upload	9	9
50	Deer	Unable to Upload	9	9
51	Monkey	Big monkey	10	10
52	Monkey	Big monkey	10	10
53	Monkey	Little Monkey
54	Monkey	Fat Monkey
Sheet1

Cell Formulas
Range	Formula
D2:D54	D2	=IF(COUNTIF($B$2:$B$54,B2)>1,IF(COUNTIF($B$2:B2,B2)=1,MAX($D$1:D1)+1,D1),"")