I searched on the board for duplicates and could not find what I needed.
How could I create a macro to rename the duplicate cells in a column and delete other cells that is not duplicate?
Is subtotal the only way to do this kinda job? Thank you all.
How could I create a macro to rename the duplicate cells in a column and delete other cells that is not duplicate?
Is subtotal the only way to do this kinda job? Thank you all.
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Name | Count | ||||
2 | IXC | 2 | ||||
3 | BAS | 1 | ||||
4 | TGB | 1 | ||||
5 | WAV | 5 | ||||
6 | BAS | 3 | ||||
7 | IDT | 3 | ||||
8 | ITA | 9 | ||||
9 | FRA | 8 | ||||
10 | QWE | 8 | ||||
11 | FRA | 7 | ||||
12 | IDT | 6 | ||||
13 | ITA | 13 | ||||
14 | TGB | 2 | ||||
15 | ||||||
16 | Name | Count | ||||
17 | IXC | |||||
18 | BAS | Yes | ||||
19 | TGB | Yes | ||||
20 | WAV | |||||
21 | BAS | Yes | ||||
22 | IDT | Yes | ||||
23 | ITA | |||||
24 | FRA | Yes | ||||
25 | QWE | Yes | ||||
26 | FRA | |||||
27 | IDT | |||||
28 | ITA | |||||
29 | TGB | |||||
Sheet1 |