abdo meghari
Active Member
- Joined
- Aug 3, 2021
- Messages
- 471
- Office Version
- 2019
hello
I want matching the items in column B with the items in column H if the items are matched with column B then should put each matched item next to adjacent matched item in column A and delete the others not matched in the same column H .
result in column H
my list about 1000 items .
I want matching the items in column B with the items in column H if the items are matched with column B then should put each matched item next to adjacent matched item in column A and delete the others not matched in the same column H .
DL .xlsm | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Sr | Description | QTY | LIST | ||||||
2 | 1 | BS 185/70R13 EP150 INDO | 184 | BS 195R14C R623 THI | ||||||
3 | 2 | BS 185R14C R624 INDO | 16 | BS 195R14C 613V JAP | ||||||
4 | 3 | BS 175/65R14 B250 THI | 50 | BS 195R14C R660 TR | ||||||
5 | 4 | BS 175/65R14 B250 INDO | 30 | BS 195/70R14 150 EZ THI | ||||||
6 | 5 | BS 175/70R14 EP150 THI | 25 | BS 205R14C 613V JAP | ||||||
7 | 6 | BS 165 R13C R624 INDO | 50 | BS 205R14C R624 INDO | ||||||
8 | 8 | BS 165 R13C R624 INDO | 46 | BS 215R14C R624 INDO | ||||||
9 | 9 | BS 175/70R13 B250 INDO | 1 | BS 185/65R15 B250 JAP | ||||||
10 | BS 185/65R15 T005 INDO | |||||||||
11 | BS 185/65R15 T01 JAP | |||||||||
12 | BS 175/65R14 B250 INDO | |||||||||
13 | BS 175/70R14 EP150 THI | |||||||||
14 | BS 165 R13C R624 INDO | |||||||||
15 | BS 185R14C R624 INDO | |||||||||
16 | BS 175/65R14 B250 THI | |||||||||
17 | BS 165 R13C R624 INDO | |||||||||
18 | BS 175/70R13 B250 INDO | |||||||||
19 | BS 185/70R13 EP150 INDO | |||||||||
20 | BS 185/70R13 EP150 INDO | |||||||||
purchase |
result in column H
DL .xlsm | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Sr | Description | QTY | ITEM | LIST | |||||
2 | 1 | BS 185/70R13 EP150 INDO | 184 | 1 | BS 185/70R13 EP150 INDO | |||||
3 | 2 | BS 185R14C R624 INDO | 16 | 2 | BS 185R14C R624 INDO | |||||
4 | 3 | BS 175/65R14 B250 THI | 50 | 3 | BS 175/65R14 B250 THI | |||||
5 | 4 | BS 175/65R14 B250 INDO | 30 | 4 | BS 175/65R14 B250 INDO | |||||
6 | 5 | BS 175/70R14 EP150 THI | 25 | 5 | BS 175/70R14 EP150 THI | |||||
7 | 6 | BS 165 R13C R624 INDO | 50 | 6 | BS 165 R13C R624 INDO | |||||
8 | 7 | BS 175/70R13 B250 INDO | 8 | 7 | BS 185/70R13 EP150 INDO | |||||
9 | 8 | BS 165 R13C R624 INDO | 46 | 8 | BS 165 R13C R624 INDO | |||||
10 | 9 | BS 175/70R13 B250 INDO | 1 | 9 | BS 175/70R13 B250 INDO | |||||
11 | ||||||||||
purchase |
Last edited: