I want to use the Accountandsubaccountwithhistory formula to bring back the list of Account/subaccount combinations that have been used in the system. Then I want to use the Accountendingbalance formula and need to reference the Account and subaccount separately from the results of the Accountandsubaccountwithhistory formula. How do I do this? If I try and reference the account field and add the # sign (example A2#) get error because the array has multiple columns that are brought back.
0 Votes
2 Comments
Sorted by
D
Dianahposted
about 4 hours ago
Thank You Harry. This is exactly what I was looking for.
0 Votes
H
Harry Lewisposted
about 6 hours ago
If you want to reference just the Account Number (and not the subaccount), you can use the Excel, INDEX function to reference just the first column of the array.
0 Votes
I want to use the Accountandsubaccountwithhistory formula to bring back the list of Account/subaccount combinations that have been used in the system. Then I want to use the Accountendingbalance formula and need to reference the Account and subaccount separately from the results of the Accountandsubaccountwithhistory formula. How do I do this? If I try and reference the account field and add the # sign (example A2#) get error because the array has multiple columns that are brought back.
0 Votes
2 Comments
Dianah posted about 4 hours ago
Thank You Harry. This is exactly what I was looking for.
0 Votes
Harry Lewis posted about 6 hours ago
If you want to reference just the Account Number (and not the subaccount), you can use the Excel, INDEX function to reference just the first column of the array.
e.g., =AccountTurnover(Connection,"Actual",,INDEX(A2#,,1),,,StartDate,EndDate)
1 Votes
Login or Sign up to post a comment