Categories
Applications
Business Finance
Database Management
Email & News Convertor
Inventory Systems
Multimedia & Design
Personal Finance
Personal Info Managers
Presentation Tools
Project Management
Software Development
Spreadsheets
Web Authoring & Development
Word Processing


Related
Multiple Regression Analysis
The Multiple Regression Analysis and Forecasting template provides a solid...
EXCEL to MySQL
Access-to-MSSQL is a program to move MS Access databases to MS SQL server....
MSSQL to EXCEL
Access-to-MSSQL is a program to move MS Access databases to MS SQL server....
MYSQL to Excel
MSSQL-to-Excel is a program to publish Microsoft SQL databases as Microsoft...
Project Management - Excel Business Tools
The Project Planning and Management excel template is designed as a generic...
Home : Business Finance : SpreadSheet :
Excel OzGrid Plus With Duplication Manager

Excel OzGrid Plus With Duplication Manager help you manage your Excel easily by offering you the options such as Formula Report Generator, Dynamic Range Namer, Real Calendar, Sheet Creator and Sorter, A Random Number Generator, Conditional Row Deletion, Duplication Report, Excel Duplication Manager Add-in and File Size Reducer.



Buy Now Download


Main features and options:

  • Formula Report Generator allows you to easily create a report showing formulas within your Workbook that are either external references, internal references or both. You can also nominate which Worksheet(s) to use to base your report on.
  • Dynamic Range Namer allows you to quickly and easily create any one of eight different types of dynamic ranges that will expand down rows or across columns. You can even nominate the column or row to use as the criteria. It can also expand automatically each day month or week.
  • Real Calendar creates a live calendar for reference in an instant using real dates. The current day is always highlighted and updates automatically.
  • Sheet Creator and Sorter creates 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.
  • Conditional Row Deletion saves many hours of repetitive work when you need to quickly and easily delete rows in a Worksheet that meet any criteria. It 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.
  • A Random Number Generator produces up to 1000 non-repeating random numbers that meet a criteria you specify.
  • File Size Reducer help you reduce unrealistic file size by a half or more.
  • Do On Time 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.