In Excel versions 2007 and later, it is much easier to find duplicates using Conditional, Formatting, Highlight Cells Rules, Duplicate Values. After select the row(s) or column(s) desired and using the process above, use the column filter and filter for cell color or whatever you criteria indicated.