Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Tools For Excel Tables

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


Multiple Conditional Excel Analysis & Formatting

BUY |TOOLS FOR Excel Tables Start

Multiple Conditional Analysis & Formatting

Multiple conditional analysis & formatting is the tool suitable to format cells in a database based on a criterion previously specified in the decision table. Besides, this tool generates a most useful pivot table with mathematical operations in selected fields of the database .For the following example, you will need a database and a decision table.

Once you have entered the information in the dialog as shown above, click on the Do It button. The result is shown below:


If in addition if you wish to have a report in a pivot table with mathematical operations in each field of the database, just check the Add category checkbox in the dialog to enable this option.Then click on the Add pivot table report button, and choose the fields and math operations you want to perform.

BACK TO TOOLS FOR Excel Tables Start

Tools for Excel Tables    Secure Payment Options

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

Special ! Free Choice of Complete Excel Training Course OR Excel 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. Send payment proof to [email protected] 31 days after purchase date.

See Also: Excel ADD-INS Index Or, All Software

Instant Download and Money Back Guarantee on Most Software

Microsoft Excel - From Beginner to Expert in 6 Hours

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

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

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