#NAME is the error Excel returns when it cannot determine the syntax in your formula. As of this writing, we are seeing more frequent instances of #NAME being related to formulas that have been modified by Excel itself. Rather nefarious. An example of one of these is =FUNCRES.xlam =SCOTT_GLACCOUNT SOLVER.xlam The cause of this …
The following Power Tip comes to us from Scott’s Add-in user and Excel guru, David Clements. David provides insights on how to leverage the =SCOTT.GLMULTI function and Excel. Thank you, David! The new =SCOTT.GLMULTI function allows multiple account inputs. While this method of selecting individual cells or ranges may be appealing to some, it is …
We have added a new function =SCOTT.GLMULTI . This powerful new function allows the user to specify non-consecutive GL accounts. The user can also specify a range in the formula. The syntax is: =SCOTT.GLMULTI (OrgID, StartDate, EndDate, [Accounts], [Accounts],…..) Here is an example: =SCOTT.GLMULTI (A1, A2, A3, B5, B8, B10:B15, B20) Where: A1 = Scotts …
We 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 …
You may have just a few hundred cells in your Excel sheet that contain =SCOTT functions. Or you may have 400,000. Yes, we do have a user who has that many! As your use of the add-in grows, and your sheets become larger, you may experience longer recalculation times. Here a 5 tips to …
We are pleased to announce the release of a new function:=SCOTT.XTRACKM For those of you that are new to these pages, Scott’s Add-in for Excel and Xero, is a series of new, custom Excel functions that enable users to dynamically sum up Xero general ledger transactions into a single Excel cell. This new function builds …
=XTRACKR extends our add-in for Xero, by allowing you to specify a range of Xero GL account codes, tracking category, and tracking option. The syntax looks like this =XTRACKR (Begin Account Code, Ending Account Code, Tracking Category,Tracking Option,Start Date,End Date) Some “use cases” of =XTRACKR include building a matrix P&L with departments or stores in …
During our launch of Scott’s Add-ins at Xerocon, we heard from a number of Xero advisors about the importance of having an Excel function that addresses Xero’s Tracking Category capabilities. With this in mind, we have developed our newest function =XTRACK =XTRACK extends our add-in for Xero, by allowing you to specify the Xero GL …
Shoot us an email and we
will do our best to
respond quickly.
Copyright © 2023 Scotts-add-ins