abdo meghari
Well-known Member
- Joined
- Aug 3, 2021
- Messages
- 612
- Office Version
- 2019
Hello
I have many items in column A . I want compare the items in column A with the others columns , if they are duplicated items & and matching the same thing ( should be the same spaces and the same letters sizes ) then should delete the duplicates items . and if there is different spaces and different letters sizes then shouldn't delete it and considers new item should highlight by red as in result in sheet output. short words when matching the items should be sensitive for letters & spaces .
I put a little items in sheet output to understand how result should be . data could be 1400 rows .
thanks
I have many items in column A . I want compare the items in column A with the others columns , if they are duplicated items & and matching the same thing ( should be the same spaces and the same letters sizes ) then should delete the duplicates items . and if there is different spaces and different letters sizes then shouldn't delete it and considers new item should highlight by red as in result in sheet output. short words when matching the items should be sensitive for letters & spaces .
I put a little items in sheet output to understand how result should be . data could be 1400 rows .
thanks
| REMOVE (1).xlsm | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | BRAND | BRAND | BRAND | BRAND | ||
| 2 | BS 1200 R20 18PR G580 JAP | BS 1200 R20 18PR G580 JAP | BS 13 R22.5 R187 JAP | BS 1200 R20 18PR G580 JAP | ||
| 3 | BS 1200 R20 18PR G580 THI | BS 1200 R20 18PR G580 THI | BS 1400R20VSJ TCF JAP | BS 1200 R20 18PR G580 THI | ||
| 4 | BS 1200 R24 G582 JAP | BS 13 R22.5 R187 JAP | BS 175/70R14 EP150 THI | BS 13 R22.5 R187 JAP | ||
| 5 | BS 13R22.5 R187 JAP | BS 1400R20VSJ TCF JAP | BS 185/65R14 EP150 IND | BS 1400R20 VSJ TCF JAP | ||
| 6 | BS 1400R20VSJ TCF JAP | BS 175/70R13 EP150 THI | BS 185/65R15 B250 JAP | BS 155 R12C R624 INDO | ||
| 7 | BS 155 R12C R624 INDO | BS 175/70R14 EP150 THI | BS 185/65R15 T01 JAP | BS 175/70R13 EP150 THI | ||
| 8 | BS 185/65R14 EP150 INDO | BS 185/65R14 EP150 INDO | BS 195/55 R16 EP300 THI | BS 175/70R14 EP150 THI | ||
| 9 | BS 185/65R15 B250 JAP | BS 185/65r15 B250 JAP | BS 195/60 R15 EP150 THA | BS 185/65R14 EP150 INDO | ||
| 10 | BS 185/65R15 T01 JAP | BS 195/55 R16 EP300 THI | BS 195/60R15 T001 JAP | BS 195/55 R16 EP300 THI | ||
| 11 | BS 195/60 R15 EP150 THI | BS 195/75R16C R613 JAP | BS 195/70R15C R623 JAP | BS 195/60R15 T001 JAP | ||
| 12 | BS 195/65R15 EP15 JAP | BS 195R14C 613 JAP | BS 195/75R16C R613 JAP | BS 195/75R16C R613 JAP | ||
| 13 | BS 195R14C 613 JAP | BS 195R14C R623 THI | BS 195R14C 613 JAP | BS 195R14C 613 JAP | ||
| 14 | BS 195R15C 613V JAP | BS 195R15C 613V JAP | BS 195R15C 613V JAP | BS 195R14C R623 THI | ||
| 15 | BS 195R15C R623 THI | BS 195R15C R623 THI | BS 195R15C R623 THI | BS 195R15C 613V JAP | ||
| 16 | BS 205/60R16 T001 JAP | BS 205/65 R16 EP300 INDO | BS 205/60R16 T001 JAP | BS 195R15C R623 THI | ||
| 17 | BS 205/65 R16 EP300 INDO | BS 205/65R15 EP150 INDO | BS 205/65 R16 EP300 IND | BS 205/60R16 T001 JAP | ||
| 18 | BS 205/65R15 T005 THI | BS 205/65R15 T005 THI | BS 205/65R15 T005 THI | BS 205/65 R16 EP300 INDO | ||
| 19 | BS 205/70R15C R623 THI | BS 205/70R15C R623 THI | BS 205/70R15C R623 THI | BS 205/65R15 T005 THI | ||
| 20 | BS 205R16C D840 THI | BS 205R16C D840 THI | BS 205R16C D840 THI | BS 205/70R15C R623 THI | ||
| 21 | BS 215/50 R17 EP300 THI | BS 215/50 R17 EP300 THI | BS 215/55 R16 EP300 IND | BS 205R16C D840 THI | ||
| 22 | BS 215/55R17 GR90 INDO | BS 215/55 R16 EP300 INDO | BS 215/55R17 GR90 IND | BS 215/50 R17 EP300 THI | ||
| 23 | BS 215/70R15C R623 THI | BS 215/55R17 GR90 INDO | BS 215/60R16 EP300 THI | BS 215/55 R16 EP300 INDO | ||
| 24 | BS 225/40R18PR 050A JAP | BS 215/60R16 EP300 THI | BS 215/70R15C R623 THI | BS 215/70R15C R623 THI | ||
| 25 | BS 225/60R16 T001 JAP | BS 215/70R15C R623 THI | BS 225/55 R16 EP300 IND | BS 225/60R16 T001 JAP | ||
| 26 | BS 225/70R15C R623 JAP | BS 225/40R18PR 050A JAP | BS 225/55R17 EP300 THI | BS 225/70R15C R623 JAP | ||
| 27 | BS 225/70R16 D687 JAP | BS 225/55R17 EP300 THI | BS 225/60R16 EP300 IND | BS 225/70R16 D687 JAP | ||
| 28 | BS 225/70R16 H005 THI | BS 225/60R16 T001 JAP | BS 225/70R15C R623 JAP | BS 225/70R16 H005 THI | ||
| 29 | BS 235/55 R17 T005 THI | BS 225/70R15C R623 JAP | BS 225/70R16 H005 THI | BS 235/55 R17 T005 THI | ||
| 30 | BS 245/45R17 T05A JAP | BS 225/70R16 H005 THI | BS 245/70R16 D684 THI | BS 235/55R17 ER300 JAP | ||
| 31 | BS 245/45R18 EP300 THI | BS 235/55 R17 T005 THI | BS 245/70R17 684A JAP | BS 235/60R16 T01 JAP | ||
| 32 | BS 245/75R17 693A JAP | BS 235/60R16 T01 JAP | BS 245/75R17 693A JAP | BS 235/60R18 D-SPORT JAP | ||
| 33 | BS 255/70R15C D840 THI | BS 245/40R18PR 050A JAP | BS 255/70 R16 D697 THI | BS 245/70R16 D684 THI | ||
| 34 | BS 265/65R17 D840 JAP | BS 245/45R18 EP300 THI | BS 255/70R15C D840 THI | BS 255/70R15C D840 THI | ||
| 35 | BS 265/70R16 D697 THI | BS 245/75R17 693A JAP | BS 265/50R20 DHPA JAP | BS 265/60R18 D840 JAP | ||
| 36 | BS 315/80R22.5 R152 JAP | BS 255/70R15C D840 THI | BS 265/65R17 D840 JAP | BS 265/65R17 D840 JAP | ||
| 37 | BS 315/80R22.5 R184 JAP | BS 265/65R17 D840 JAP | BS 275/40R20 Dsport JAP | BS 275/40R20 Dsport JAP | ||
| 38 | BS 325/95R24 G582 JAP | BS 265/70R16 D697 THI | BS 275/65R18 AL01 JAP | BS 285/65R17 R683 JAP | ||
| 39 | BS 385/65 R22.5 R164 JAP | BS 315/80R22.5 R184 JAP | BS 315/80R22.5 R184 JAP | BS 315/80R22.5 R184 JAP | ||
| 40 | BS 425/65R22.5 R164 JAP | BS 315/80R22.5 R184 THI | BS 385/65 R22.5 R164 JAP | BS 315/80R22.5 R184 THI | ||
| 41 | BS 750R16 R230 TCF JAP | BS 315/80R22.5-18PR G580 JAP | BS 385/65 R22.5 R164 THA | BS 385/65 R22.5 R164 JAP | ||
| 42 | BS 750R16 VSJ TCF JAP | BS 385/65 R22.5 R164 JAP | BS 750R16 R230 TCF JAP | BS 385/65 R22.5 R164 THI | ||
| 43 | DT 315/80r22.5 DS50 THI | BS 385/65 R22.5 R164 THI | BS 750R16 VSJ TCF JAP | BS 425/65R22.5 R164 JAP | ||
| 44 | DT 385/65r22.5 DT40 THI | BS 750R16 R230 TCF JAP | DT 315/80r22.5 DS50 THI | BS 650R16 R230 JAP | ||
| 45 | BS 1200R24 G580 JAP | BS 750R16 VSJ TCF JAP | FS 215/55R17 TZ700 JAP | BS 750R16 R230 TCF JAP | ||
| 46 | BS 255/70R16 H005 THI | DT 315/80r22.5 DS50 THI | FS 225/45R17 TZ700 JAP | BS 750R16 VSJ TCF JAP | ||
| 47 | BS 265/70R16 D840 THI | DT 385/65r22.5 DT40 THI | FS 31*10.50R15 DEST AT IND | DT 315/80r22.5 DS50 THI | ||
| 48 | BS 275/70R16 H005 THI | FS 205/65R15 TZ700 JAP | FS 215/60R16 ROADHAWK ITALY | DT 385/65r22.5 DT40 THI | ||
SHEET1 | ||||||
| REMOVE (1).xlsm | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | ITEM | BRAND | ||
| 2 | 1 | BS 1200 R20 18PR G580 JAP | ||
| 3 | 2 | BS 1200 R20 18PR G580 JAP | ||
| 4 | 3 | BS 1200 R20 18PR G580 THI | ||
| 5 | 4 | BS 1200 R24 G582 JAP | ||
| 6 | 5 | BS 13R22.5 R187 JAP | ||
| 7 | 6 | BS 13 R22.5 R187 JAP | ||
| 8 | 7 | BS 13 R22.5 R187 JAP | ||
| 9 | 8 | BS 13 R22.5 R187 JAP | ||
| 10 | 9 | BS 1400R20VSJ TCF JAP | ||
| 11 | 10 | BS 1400R20 VSJ TCF JAP | ||
| 12 | 11 | BS 155 R12C R624 INDO | ||
| 13 | 12 | BS 185/65R14 EP150 INDO | ||
| 14 | 13 | BS 185/65R15 B250 JAP | ||
| 15 | 14 | BS 185/65r15 B250 JAP | ||
OUTPUT | ||||
