Show Duplicates: provides case and non-case sensitive search options to find duplicates. Items that are duplicated are highlighted.
All Repeats: finds all repeating values including the duplicates and highlights there cells with an infill colour. When done a form loads containing a list of the repeat values. The list can then be used to navigate and view the repeat items on the worksheet.