Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Excel Breaches. Looking for Missing Data

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS


Back to Tools for Excel Tables Start

If you wish to look for missing records in a data base through a field that contains a sequence
(either numeric or date values) this tool will do it for you.
Procedure is the following:
Select a cell that be a part of a data base or select manually the range to be evaluated.
Click on the corresponding button to display the Breaches dialog box (values or dates)
1. Select the field to be evaluated.
2. You must enter the value from where the valuation will start off, in the "Start value" field.
3. You should to enter the jump that it will give between each searched value. In this case is 1.
4. You also, must enter the final value to be evaluated, in the "End value".
Finally press the Do it button.



Back to Tools for Excel Tables Start

1 $89.95 USD
2 - 5 Licenses $79.95 USD
6 - 9 Licenses $72.50 USD
10+ Licenses $54.95 USD

Tools for Excel Tables    Secure Payment Options

Free Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on ALL purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH!  Purchases MUST be made via this site.

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us