Range Functions

The Range functions help return a dynamic array of values either vertically or horizontally based on the input parameters. These functions can make it easier to cross check that a financial report has all required accounts, outline a horizontal list of all needed locations, return a sub-set of accounts based on filters, and more. Wildcard characters can be used in the include and exclude filter parameters to control the items returned. The dynamic array returned is a native Excel feature, and any Excel function that works on a dynamic array can consume the values returned by these functions.

Functions

Review the functions under the Range section below:

• Accounts Range
• Classes Range
• Departments Range
• Entities Range
  • Companies Range
  • Contacts Range
  • Customers Range
  • Employees Range
  • Generic Resources Range
  • Groups Range
  • Other Names Range
  • Partners Range
  • Projects Range
  • Project Templates Range
  • Vendors Range
• Items Range
• Locations Range
• Subsidiaries Range

Note: Because these functions are likely producing an array which will span multiple cells, the word #SPILL! may get returned in the case of the function not having the room to expand their result across the needed cell range. The array must be able to spill into empty cells, and if a cell is encountered with a formula or value, you will receive the #SPILL! error. To resolve this, ensure no inputs are placed inside of cells that are needed for the returned range by clearing out the cells with values or inserting additional rows/columns as required.

Entities are broken out by type (Companies, Customers, Vendors, etc.) to improve usability and performance. Use the specific entity type function when possible instead of the generic Entities Range function.