Macro or Formula to highlight duplicate values

[Dazzawm]

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

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

 

[Fluff]

Maybe
=SUMPRODUCT(($C$2:$C$13=$C2)*($AD$2:$AD$13=$AD2)*($AH$2:$AH$13=$AH2))>1

 

[Dazzawm]

Every result is False? The spreadsheet will start row 2 down to about 100,000.

 

[Fluff]

This is what I get from the data you showed

Excel 2013/2016
	C	D	E	F
2	FDFIE12 1001	WFB19	FR DS	FALSE
3	FDFIE12 1001	WFB19	FR PS	TRUE
4	FDFIE12 1001	WFB19	FR PS	TRUE
5	FDFIE12 1001	NYA	RR	FALSE
6	FDFIE12 1004	WFB19	FR DS	FALSE
7	FDFIE12 1004	WUV19	FR PS	FALSE
8	FDFIE12 1004	WFB19	FR PS	FALSE
9	FDFIE12 1004	NYA	RR	FALSE
10	FDFIE12 1008	WFB22	FR DS	TRUE
11	FDFIE12 1008	WFB22	FR DS	TRUE
12	FDFIE12 1008	WFB16	FR PS	TRUE
13	FDFIE12 1008	WFB16	FR PS	TRUE
Sheet2

Cell Formulas
Range	Formula
F2	=SUMPRODUCT(($C$2:$C$13=$C2)*($D$2:$D$13=$D2)*($E$2:$E$13=$E2))>1

Coloured cells represent what I get using the formula in CF

 

[Dazzawm]

I still cant get it to work. In the formula it seems to have the final row as 13 like the example is, like I say mine has about 100,000+

 

[Fluff]

Just change the 13 to a number that you are unlikely to exceed

 

[Dazzawm]

Thanks Fluff, think I've sorted it.

 

[Fluff]

Glad to here that & thanks for the feedback