Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,751
- Office Version
- 365
- Platform
- Windows
I have a sheet with data set out as below. I need a macro or formula that will either highlight duplicate values or remove them.
The code firstly needs to look at column C. When they all match it then needs to look at column AD and AH to see if there are duplicates.
In the example below you can see I have highlighted 3 different set of values in C. In the first set AD3, AD4 and AH3 and AH4 match so these are highlighted.
In the second set in C there are no duplicates (only in AD) so this is ignored.
In the last set they are 2 lots of duplicates.
Thanks
The code firstly needs to look at column C. When they all match it then needs to look at column AD and AH to see if there are duplicates.
In the example below you can see I have highlighted 3 different set of values in C. In the first set AD3, AD4 and AH3 and AH4 match so these are highlighted.
In the second set in C there are no duplicates (only in AD) so this is ignored.
In the last set they are 2 lots of duplicates.
Thanks
Excel 2010 | |||||
---|---|---|---|---|---|
C | AD | AH | |||
2 | FDFIE12 1001 | WFB19 | FR DS | ||
3 | FDFIE12 1001 | WFB19 | FR PS | ||
4 | FDFIE12 1001 | WFB19 | FR PS | ||
5 | FDFIE12 1001 | NYA | RR | ||
6 | FDFIE12 1004 | WFB19 | FR DS | ||
7 | FDFIE12 1004 | WUV19 | FR PS | ||
8 | FDFIE12 1004 | WFB19 | FR PS | ||
9 | FDFIE12 1004 | NYA | RR | ||
10 | FDFIE12 1008 | WFB22 | FR DS | ||
11 | FDFIE12 1008 | WFB22 | FR DS | ||
12 | FDFIE12 1008 | WFB16 | FR PS | ||
13 | FDFIE12 1008 | WFB16 | FR PS | ||
Sheet1 |