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)
PeterBartholomew1
Apr 24, 2023Silver Contributor
I combined your workbook and my named formulae
and things still seem to work. If I were developing such solutions I would probably write further Lambda functions to break the formula into smaller parts and to encapsulate the detail that need not be exposed to an end user.