LAMBDA function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/lambda-function/ Bestselling Excel and Power BI Courses Fri, 24 Mar 2023 08:33:07 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png LAMBDA function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/lambda-function/ 32 32 Excel LAMBDAs Made Easy with the New Advanced Formula Environment (Editor) https://www.xelplus.com/excel-advanced-formula-editor/ Fri, 04 Mar 2022 12:31:00 +0000 https://www.xelplus.com/?p=9462 The new Microsoft Excel Advanced Formula Add-in makes it easy to write and manage LAMBDAs in Excel.
It's a "new" version of Name Manager and hopefully it could replace Name Manager in the future.

The post Excel LAMBDAs Made Easy with the New Advanced Formula Environment (Editor) appeared first on Xelplus - Leila Gharani.

]]> How to Use SCAN Function in Microsoft Excel https://www.xelplus.com/scan-function-in-excel/ Fri, 05 Nov 2021 14:44:00 +0000 https://www.xelplus.com/?p=9746 Learn how to use the new Excel SCAN function! This function is a Lambda helper function. You can use it to "scan" a range and apply a calculation to each cell. In this example you'll learn how to use SCAN to get to-date values and how you can tweak it to return YTD values.

The post How to Use SCAN Function in Microsoft Excel appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel BYROW and BYCOL Helper Functions for LAMBDA https://www.xelplus.com/excel-byrow-bycol-functions/ Thu, 23 Sep 2021 08:00:00 +0000 https://www.xelplus.com/?p=8880 Find out how you can use the new Excel BYROW and BYCOL functions. These are called Lambda helper functions and they can help you save a lot of time if your analysis is based on a whole row or an entire column. Check out this practical example to find out more.

The post How to Use Excel BYROW and BYCOL Helper Functions for LAMBDA appeared first on Xelplus - Leila Gharani.

]]> Excel LAMBDA Function Explained https://www.xelplus.com/excel-lambda-function-explained/ Thu, 17 Dec 2020 10:00:00 +0000 https://www.xelplus.com/?p=9037 With the new Excel Lambda function you can create your own custom functions that you can reuse. The best thing about Excel Lambdas is you can create a function that loops through many cells. You can do this with ZERO coding! In part 1, discover the LAMBDA logic and learn how to write your first Lambda.

The post Excel LAMBDA Function Explained appeared first on Xelplus - Leila Gharani.

]]> How a Recursive LAMBDA Works https://www.xelplus.com/how-a-recursive-lambda-works/ Thu, 17 Dec 2020 10:00:00 +0000 https://www.xelplus.com/?p=13441 With the new Excel Lambda function you can create your own custom functions that you can reuse. The best thing about Excel Lambdas is you can create a function that loops through many cells. You can do this with ZERO coding! In part 2, we will create a Lambda function that can reference itself.

The post How a Recursive LAMBDA Works appeared first on Xelplus - Leila Gharani.

]]>