This very handy add-in will make your management of lists a breeze. It is designed to assist you when you have duplicates in 1 or more lists. You can create a list of uniques, hide all duplicates, create a summary report, color code all duplicates (up to 3 levels) and even *prevent* users from adding duplicates to a list or table! There is also the option to compare 2 lists for matching entries.
Have a list where entries are repeated over and over? There is now an option to remove all but the first occurence of each duplicate entry.
Have a list where entries are NOT repeated over and over, leaving blank cells between? There is now an option to fill all these blank cells with the data in the cell directly above.
Come with the FREE File Size Reducer:
It's a common problem with Excel Workbooks to increase in size unrealistically, even after you think you have cleared out all the data. The File Size Reducer has become extremely popular as it can reduce unrealistic file size by 50% or more! All you need to do is install the add-in and click the button. | 
Download Trial
Buy