![YouTube video player](https://i.ytimg.com/vi/y-m39FVA59c/hqdefault.jpg)
Microsoft Excel Tips and Tricks
In this Microsoft Excel video tutorial I explain how to compare two worksheets and identify duplicates; I demonstrate two methods. The first method uses the COUNTIF function and the second method uses conditional formatting.
Credit Chester Tugwell