excel highlight and remove duplicates

Macro 56: Highlight Duplicates in a Range of Data Ever wanted to expose the duplicate values in a range? The macro in this section does just that. There are many manual ways to find and highlight duplicates — ways involving formulas, conditional for- matting, sorting, and so on. However, all these manual methods take setup […]