Forum Discussion
Hogstad_Raadgivning
Jul 15, 2023Steel Contributor
Build a dynamic list with VSTACK based on the table list.
Hi,
I might be pushing it now. But it is maybe a solution for this.
The goal is to make VSTACK dynamic, build a table based on the table names in the workbook.
The green table is a named list of the tables in the workbook. (Made with power query).
Using indirect and any other function is it possible to build one formula using VSTACK? Make the "non dymanic function" dynamic?
Best regards
- Geir
- DESCRIPTION
The `New-LocalUser` cmdlet creates a local user account. This cmdlet creates a local user account or a local user account that is connected to a Microsoft account.
> [!NOTE] > The Microsoft.PowerShell.LocalAccounts module is not available in 32-bit PowerShell on a 64-bit > system
Have the same issue, does work in PowerShell v5. It does work after running import-module microsoft.powershell.localaccounts -UseWindowsPowerShell (Effectively running it in PowerShell v5 mode in PowerShell v7)
2 Replies
Sort By
- OliverScheurichGold Contributor
=REDUCE({"Name","City","Rng"},SEQUENCE(ROWS(Tabelle5[Table])),LAMBDA(x,y,VSTACK(x,INDIRECT(INDEX(Tabelle5[Table],y,1)))))
You can try this LAMBDA function. The names of the three tables on the left in the example are Tabelle2, Tabelle3 and Tabelle4. The name of the small blue table which references the table names is Tabelle5.
- Hogstad_RaadgivningSteel ContributorGreat, it worked perfect. Thank you.