I thank each and every Mr. Excel forum members who are helping hundreds of Productivity Issues daily.
I am looking for a solution to remove similar duplicates by identifying the Pattern which every text ends with a Number.
Based on Column A (primary key) - the macro should run on column B data, by matching the similar text name ends with a Number.It should trim the extra spaces and delete the numbers and special characters around it.
Later macro should delete the Column B duplicates based on column A and results should be populated in column D and E.
Sample data
I am looking for a solution to remove similar duplicates by identifying the Pattern which every text ends with a Number.
Based on Column A (primary key) - the macro should run on column B data, by matching the similar text name ends with a Number.It should trim the extra spaces and delete the numbers and special characters around it.
Later macro should delete the Column B duplicates based on column A and results should be populated in column D and E.
Sample data
Book7 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | ID | RAW DATA | Primary | Remove duplicate and Keep Unique | |||
2 | CD-001 | Toggle Method - 1 | CD-001 | Toggle Method | |||
3 | CD-001 | Toggle Method - 2 | CD-002 | Update Action -part | |||
4 | CD-002 | Update Action - Part 1 | CD-003 | Add Form - Part | |||
5 | CD-002 | Update Action - Part 2 | CD-004 | Code Implementation | |||
6 | CD-003 | Add Form - Part (1) | CD-005 | Create and run a while loop, part | |||
7 | CD-003 | Add Form : Part (2) | CD-006 | VBA Framework Lecture | |||
8 | CD-004 | Code Implementation I | CD-007 | VBA Project Video | |||
9 | CD-004 | Code Implementation II | CD-008 | VBA Command Video | |||
10 | CD-005 | Create and run a while loop, part 1 | CD-009 | Player Setup P | |||
11 | CD-005 | Create and run a while loop, part 2 | CD-010 | The registerNewUser method part | |||
12 | CD-006 | VBA Framework Lecture:-1 | CD-011 | HTML Form @ Part | |||
13 | CD-006 | VBA Framework Lecture:-2 | CD-012 | VBA Function | |||
14 | CD-007 | VBA Project Video - i | CD-013 | Let's create Macro Pt | |||
15 | CD-007 | VBA Project Video- ii | CD-014 | Source Code Lesson | |||
16 | CD-008 | VBA Command Video1 | CD-015 | VBA Functions - Chapter | |||
17 | CD-008 | VBA Command Video 2 | CD-016 | Inbuilt Time Function | |||
18 | CD-009 | Player Setup P.1 | CD-016 | Inbuilt Date Functions | |||
19 | CD-009 | Player Setup P.2 | CD-016 | Inbuilt Text Functions | |||
20 | CD-010 | The registerNewUser method part1 | |||||
21 | CD-010 | The registerNewUser method part2 | |||||
22 | CD-011 | HTML Form @ part2 | |||||
23 | CD-011 | HTML Form @ part3 | |||||
24 | CD-012 | VBA Functions 01 | |||||
25 | CD-012 | VBA Functions02 | |||||
26 | CD-013 | Let's create Macro Pt.1 | |||||
27 | CD-013 | Let's create Macro Pt.2 | |||||
28 | CD-014 | Source Code Lesson 28 | |||||
29 | CD-014 | Source Code Lesson 29 | |||||
30 | CD-015 | VBA Functions - Chapter-1 | |||||
31 | CD-015 | VBA Functions - Chapter-2 | |||||
32 | CD-016 | Inbuilt Time Function | |||||
33 | CD-016 | Inbuilt Date Functions | |||||
34 | CD-016 | Inbuilt Text Functions | |||||
Sheet1 |