Excel OzGrid Plus With Duplication Manager

Sheet Creator and Sorter:

This option will create any number of pre-named worksheets which can be Financial Years (1901-2050), Weekdays (Monday-Sunday), Months (January-December), Years (1901-2050), Quarters (Quart1-Quart4), Days (Day1-Day1460) and Weeks (Week1-Week208). It also has an option that allows you to Sort (ascending or descending) any Worksheets in any Workbook.

A Random Number Generator:

This can produce up to 1000 non repeating random numbers that meet a criteria you specify.

Conditional Row Deletion:

This one will save many hours of repetitive work when you need to quickly and easily delete rows in a Worksheet that meet any criteria. There is an option that allows you to easily nominate any one of Excels six Error Types, or all of them. There is also a simple option that allows you to nominate the criteria.

Duplication Report:

Will produce a statistical table of your data. Including a Count of occurrences of each item, the total number of duplicates and a total of all entries. It will also produce a list of your data containing only unique entries. Better than a Pivot Table in a single click.

Excel Duplication Manager Add-in:
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 and remove duplicate lines from a table.

Do On Time:

This feature allows you to run a macro (recorded or written) at a set time, display a personal message or reminder at a specified time or even open a nominated Workbook at a set time.

Sheet Index Creator:

Have a workbook with a large number of Worksheets? Find it hard and too time consuming navigating through all the sheets? This option allows you to easily create an Index Sheet that has click-able links to all sheets. It also has the option of placing a "Back to Index" link on all the sheets.

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

This is the Shareware version. The full version can be purchased by clicking on the "Buy Now" button below for around $ USD.

Click to buy from Regnow