lambda

  1. A

    Why does non-recursive LAMBDA/LET slow things down?

    Hi all! Hopeful that you can help me speed up some of my formulas. I'm building a chain of LAMBDA functions and the most recent one is running really slowly and I can't figure out why because if I run the exact same formula just filling in the variables, it runs instantly. Details below: Runs...
  2. R

    Lambda Function that works in a TABLE

    Good evening, hope someone can help. I am trying to create lambda functions that work in various tables in a workbook. The worksheet calculates "Year To Date" (a running total) and "Previous Year to Date" (YTD from the previous row) The functions are kind of long (especially the Previous...
  3. A

    Using Lambda to create a Loan Amortization Table

    Hi all, I have created a partial formula that calculates the amount of EMI going towards interest and principal. I am, however, looking to calculate the outstanding balance after each period as well. The formula for outstanding balance for each period would be - Example Period 1 ost bal =...
  4. sleek12

    Filter out from the range that is coloured green, use those values to open new worksheet to compare and contrast

    After the reconciliation was complete, The range gives out as values in both worksheets, values only in first worksheet and values only in second worksheet. (see last portion) But my area of interest is values in both worksheets. See below. ABCDEF1dec2021CASHBOOKdec2021NBK502BOTH2AmountCount...
  5. J

    Connect to Google Sheets through Power Query with LAMBDA function

    Watching this video, I figured out how to set up a live connection to a Google Workbook through Power Query. Basically, you copy the URL for sharing, and then set up a URL with an ID gleaned from that URL. The ID is between the /d/ and the last / of the URL provided. The video is 2 years old...
  6. G

    Make array with reference (no macro)

    As we know, the new excel release is super awesome with its array range and lambda function (along with other functions to work on array/lambda). One problem that still makes me uncomfortable is making an array with reference. We can make normal array as ={1,2,3;4,5,6}. But apparently we cannot...
  7. M

    Utilizing Dynamic Arrays for Compound Annual Growth Rate

    Dear Members, I need assistance in creating a CAGR array from periodic returns vector. I wish to create a Dynamic Array holding only calculated CAGR (compound annual growth rate) values derived from periodical return on investment vector. This is easily performed in standard Excel but...
  8. Dermot

    Creating a SPLIT function in Excel using lambdas

    A SPLIT function (to break delimited text into separate cells) would be very useful. It is easy to do in VBA, which has a built in function to do it, but I thought I'd try to do it with lambdas. I found it extremely difficult (not least because it is so hard to check recursive lambdas if you...
  9. Dermot

    Copying Lambdas between workbooks and keeping them updated

    Lambdas are held in individual workbooks. How can we copy them between workbooks, and keep them up to date if they change? Based on the current Excel beta version 2111 * copying any sheet (even blank) from workbook A containing lambdas to another workbook B, will also copy those lambdas to B...
  10. T

    SUBARRAYS

    This LAMBDA provides a recursive loop to extract subarrays of given set of dimensions, or warns the user if their provided dimension(s) are bigger than their target array; I am returning the list of the subarrays using ARRAYTOTEXT, but this could be substituted with another function to suit the...
  11. dejhantulip

    Lambda function to extract strings between characters?

    Hello everyone! :) So I have been messing around lately with some data that has delimiters and I am trying (as an alternative to powerquery) to extract some strings that are in the raw data cells using the LAMBDA function. Could anyone help me out to see how I could use lambda for this? So...
  12. M

    Would be great to have Dynamic Waterfall charts with LAMBDA, where the items are dynamic. Any ideas about this from somebody?

    Would be great to have Dynamic Waterfall charts with LAMBDA, where the items are dynamic. Any ideas about this from somebody?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top