Report Offensive Message

As for people's comments so far.. there will always be more than one way of "skinning a cat" or in this case finding duplicates in Excel. To me the important part is understanding how you get there rather than the end result because you can use that knowlege for other things. The countif function is one that I'll most likely use again after reading this article.