May 2023

GLMULTI Power Tips

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 …

GLMULTI Power Tips Read More »

New Function GLMULTI

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 …

New Function GLMULTI Read More »