Recent Blog ArticlesMost RecentMost LikesRe: A new way to debug formulas from Excel Labs This will be very useful, and initial results for functions that are supported look promising... AFE results that don't match are highlighted in red below - however if entered with CSE they do match...Re: Announcing LAMBDA Helper Functions: Lambdas as arguments and more I found myself looking back at this thread following the recent 'function names as arguments' update. The update addresses some of the earlier comments in this thread - maybe we should now drop the '...Re: Formula Argument Assistance Inbar_Privman This is a great addition for general users. It'd also be really helpful if additional guidance was available on DA evaluation, which can be confusing at times, including function signa...Re: Announcing Data Types APIs: Data Types in Excel Add-ins This looks nice and will enhance many tools for trading etc. Existing xll libraries tend to use various hacks to represent an object using a cell value (eg https://www.quantlib.org/quantlibxl/index....Re: Announcing LAMBDA Helper Functions: Lambdas as arguments and more SergeiBaklan The suggestion further up was to use the same function_num input as SUBTOTAL / AGGREGATE i.e. 9=SUM. Then it could be possible to write a LAMBDA function for this purpose by checking t...Re: Announcing LAMBDA Helper Functions: Lambdas as arguments and more SergeiBaklan One shouldn't expect typical users to work with LAMBDA expressions as you say. My thought was that functions like BYCOL and SCAN could support basic aggregation needs viafunction name...Re: Announcing LAMBDA Helper Functions: Lambdas as arguments and more PeterBartholomew1 Thanks for posting these screenshots, I doubt I'll have access to this functionality for a while from current channel so will follow your posts with interest. My optimism foll...Re: Announcing LAMBDA Helper Functions: Lambdas as arguments and more I predict these new functions will become a mainstream approach to the development of models in the coming years once their power and flexibility becomes widely appreciated. Someminor updates might...Re: Announcing LAMBDA Helper Functions: Lambdas as arguments and more tboulden Great you're able to test these new features. Can you confirm if performance is now comparable with filling down single cell formulas? It looks like BYROW and BYCOL are essentially the sam...Re: Announcing LAMBDA Helper Functions: Lambdas as arguments and more PeterBartholomew1 Examples of amortisation and vector accumulations are given here and here, the python code should easily adapt to Excel syntax. My suggestion would be to infer direction of accumu...