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...