This very handy add-in will make your management of lists and duplicate data in Excel a breeze. It is designed to assist you when you have duplicates in 1 or more lists and/or tables, find duplicates in Excel, manage and find duplications.
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.

Buy Now $29.95 USD

Software Information		System Requirements
Version:	3.1	Windows 8/7/XP/Vista Microsoft Excel 97, 2000, XP and 2003 Pentium II CPU 512 MB RAM
License:	$29.95 to buy
Screenshot:	View Screenshot
Rating:

More Screenshot

Click image to enlarge!

• Create a list of unique data.
• Hide all duplicates.
• Display only unique data.
• Create a summary report.
• Color code all duplicates, up to 3 levels.
• Prevent users from adding duplicates to a list or table!
• Compare 2 lists for matching entries.
• Remove duplicates from any range.
• Remove entries from one list that exist in the other.
• Remove duplicate rows from a table.
• Have a list where entries are repeated over and over? There is now an option to remove all but the first occurrence 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.