madhuchelliah
Board Regular
- Joined
- Nov 22, 2017
- Messages
- 226
- Office Version
- 2019
- Platform
- Windows
Hello all, i have data in A column, which has unique values and duplicated values. I want to assign a name like Group 1, Group 2....
VBA has to look into all the data in A column and assign group name in D column. If any value is repeated it should be assigned with same Group name.
Thank you.
Example
VBA has to look into all the data in A column and assign group name in D column. If any value is repeated it should be assigned with same Group name.
Thank you.
Example
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Name | XXX | YYY | Group | ||
2 | AAA | Group - 1 | ||||
3 | AAA | Group - 1 | ||||
4 | CCC | Group - 2 | ||||
5 | DDD | Group - 3 | ||||
6 | EEE | Group - 4 | ||||
7 | EEE | Group - 4 | ||||
8 | EEE | Group - 4 | ||||
9 | FFF | Group - 5 | ||||
10 | FFF | Group - 5 | ||||
11 | GGG | Group - 6 | ||||
12 | HHH | Group - 7 | ||||
Sheet1 |