Forum Discussion
Using Embedded functions
Stuart_Ballinger If the variable functions you intend to choose from are in the list of function numbers used by AGGREGATE, you could do something like in the attached workbook.
Select the function to be used from the dropdown in A2. Then, B2 will find the function number. I've used MATCH, but you also use VLOOKUP, XLOOKUP or INDEX/MATCH, if you intend to use a shorter list of functions.
In C1, the AGGREGATE function is executed using the function number from B2.
Stuart_Ballinger If the variable functions you intend to choose from are in the list of function numbers used by AGGREGATE, you could do something like in the attached workbook.
Select the function to be used from the dropdown in A2. Then, B2 will find the function number. I've used MATCH, but you also use VLOOKUP, XLOOKUP or INDEX/MATCH, if you intend to use a shorter list of functions.
In C1, the AGGREGATE function is executed using the function number from B2.
- That works great. Thank you very much 🙂
