lambda

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...

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...

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...

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...

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...

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...

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...

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