BC.EXPANDACCOUNTRANGE

Overview

The BC.EXPANDACCOUNTRANGE function returns all general ledger account codes matching search criteria.

CODE

=BC.EXPANDACCOUNTRANGE(
    ConnectionName,
    Account,
    AccountType,
    IncludeBlocked
)

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager
`Account`	Optional (when empty, lists all available accounts)	The code of the general ledger account, a spill range, or a cell range containing account codes. For example, `10100`, `A1:A10` or `A1#`
`AccountType`	Optional	A string of characters (case-insensitive) corresponding to account types for which results will be returned. Available values: P - posting accounts H - heading accounts T - totaling accounts defined via account range B - begin-total accounts E - end-total accounts `PHTBE` is the default value (all types)
`IncludeBlocked`	Optional	`TRUE` (default) or `FALSE` To exclude blocked accounts from your result, set this argument `FALSE`.