I want to perform deletion for row 9 to row 23 to keep the last row of each group.
For example, for range A9:A11, there are three 13888. But I just want keep the third one as the third row is the last row of the group.
For 96758, I just want to keep the fourth one as the fourth row is the last row of the group.
13888 200
13888 56
13888 45
96758 545
96758 56
96758 45
96758 55
97727 12
97727 110
97727 898
97727 1513
97727 1231
98427 500
98427 600
98427 900
In other words, after deleting, the remains should be
13888 45
96758 55
97727 1231
98427 900
I tried to use Find function code to do it but failed.
I would thank you all any ideas in advance.
Dennis
For example, for range A9:A11, there are three 13888. But I just want keep the third one as the third row is the last row of the group.
For 96758, I just want to keep the fourth one as the fourth row is the last row of the group.
13888 200
13888 56
13888 45
96758 545
96758 56
96758 45
96758 55
97727 12
97727 110
97727 898
97727 1513
97727 1231
98427 500
98427 600
98427 900
In other words, after deleting, the remains should be
13888 45
96758 55
97727 1231
98427 900
I tried to use Find function code to do it but failed.
I would thank you all any ideas in advance.
Dennis