Scott's Add-Ins New Feature to Function =SCOTT.QALL

Scott's Add-Ins have added a new feature to function =SCOTT.QALL

Wildcards are now supported as values for parameters Class, Customer, Department, and Vendor. Wildcards open up all sorts of possibilities for building powerful dashboards to analyze financial results.

A wildcard allows you to include ALL transactions for a parameter, regardless of the value of the parameter. For example, you may wish to include all Customers, but limit the Class, Department, and Vendor to specific values. This might look like:

=SCOTT.QALL(A1,A2,A3,"*",A5,A6,A7,A8)

Note that, when entering the wildcard directly into your formula, you will need to enclose it in quotes. However, if you specify it by referencing a cell (recommended), the cell referenced should only contain the * symbol.

Here is a short video demonstrating this new feature: