Excel OzGid Plus With Duplication Manager

The OzGrid plus and Duplication Manager bundled.

Description of Excel OzGid Plus With Duplication Manager:

Formula Report Generator:
Allows you to very 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:
This will allow you to very 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:
This one will create a live calendar in an instant using real dates, so you can reference it if needed. The current day is always highlighted and updates automatically.

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 39.95

See Also: All products from OzGrid Business Applications

1. Visual Basic Macro Examples for Microsoft Excel
   Get over 1200 Microsoft Excel Visual Basic macro examples and solutions in a downloadable help file. Access directly from Excel.
2. XLS Converter
   Convert XLS to TXT,HTM,CSV,MDB,DBF in batch mode, build in preview window.
3. Loan Assistant for Microsoft Excel
   The Loan Assistant tells you in advance what your loan payments will be for any loan. It also generates amortization tables showing the amount of principal, unpaid balance and interest by week, month, or year.
4. Extended Accounting Lite Edition
   Extended Accounting Light Edition. MS Excel 97/2000/XP add-in. Data Entry Bug Tracker. Tracks entry bugs during an entry. For more info about screenshots and available product versions please visit: http://iovsoft.hypermart.net/eascreen.
5. Analysis Collection for Microsoft Excel
   Get two downloadable books on Excel macos, another on time saving solutions, and 19 time saving add-ins, including the Spreadsheet Assistant.
6. Formula Ref Changer and Sheet Index Creator
   Change formulae references in a flash. Create a index sheet with links.
7. Multiple Seek Target 1.0
   The Multiple Seek Target is an Excel add-in, which allows you to get target seek solutions to many spreadsheet cells at one time by configuring the seek target wizard. It does multiple re-calculations automatically.
8. PDAGraphiX2 (Spanish Version)
   PDAGraphiX2 es un graficador poderoso, flexible y dinmico, el cual permite realizar fcilmente grficos increbles con tan solo un click.
9. Sheet Navigataor for Microsoft Excel
   The Sheet Navigator for Microsoft Excel makes moving from one worksheet to another extremely easy. With a single click, a list of all your worksheets is displayed for your selection.
10. Visual Basic Macros Made Easy for Microsoft Excel
    Learn to write Microsoft Excel Visual Basic Macros from this downloadable book. Written by a user for users.
11. Retirement Investment Required - for Windows 3.1
    Retirinv.EXE - You can calculate the amount of money you need to be investing monthly to provide a monthly withdrawa supplemented by Social Security, pensions, annuities or other income sources.
12. Excel VBA Level 1 and Excel UserForms
    Excel VBA Training Level 1 and Excel UserForms and Controls
13. Portfolio Fundamentals - for Windows 3.1
    Portfund.EXE - This program gives you a place to input the financial data for a given stock so that you might better forecast and track its performance.
14. Chart Viewer for Microsoft Excel
    View Excel charts on a worksheet in a slide show fashion!
15. TorniaiSansUT Black PC
    TorniaiSansUT Black PC
16. Cell Color Assistant for Microsoft Excel
    Use th Cell Color Assistant in Microsoft Excel to create your own custom color toolbar.
17. TorniaiSansOsfUT RegularItalic PC
    TorniaiSansOsfUT RegularItalic PC
18. TorniaiSansOsfUT Bold PC
    TorniaiSansOsfUT Bold PC
19. Variable Rate Mortgage - for Windows 3.1
    Varimtge.exe - You can use this program to either investigate or track a variable-rate mortgage or to project the payout of this type mortgage.
20. Maxmortgage - for Windows 95 or higher
    Maxmtge.EXE - A mortgage qualifier for either a fixed- rate or variable-rate mortgage which shows how large a mortgage you qualify for.