Forum Discussion
morphil
Apr 23, 2023Copper Contributor
Iterative Lambda with indirect
Hi everybody, I would appreciate your help in order to build an Iterative and generic Lambda with indirect to replace basic Nested If formula Inputs : One CLPC_Status Excel table with Tab_Name and...
- Apr 27, 2023
Power Query option attached
Note that the 1st Refresh within an Excel session takes more time (time for the .Net Framework to load) that the next Refresh(es)
mathetes
Apr 23, 2023Silver Contributor
It would help us all help you if you could post a copy of your workbook on OneDrive or GoogleDrive, with a link pasted here that grants access.
In the absence of that, you're asking (in effect) that we create a formula in a vacuum OR create what we think your workbook looks like and then create that formula, in every case running the risk of not at all replicating your situation.