Create Named Functions in Excel & Google Sheets - LAMBDA UDF

[@lpanebr]

I'm so happy they didn't take too long to bring this to Google sheets!

[@anhthangzoro1171]

Amazing, thank you so much for sharing all things. My wife have a small business, she need “a software” to manage all the bill, stock, customers, staff, deliver … I created a “software” to solve all her need. And your channel helped me so much to do all of that. Thank you so much !!!! ❤❤❤ A big thanks from Vietnam ❤

[@ScampMichael]

Stupendous!

[@ExcelGoogleSheets]

Thank You!

[@xaquison]

THANK YOU, THANK YOU, THANK YOU. The way you explain things that even a one-year old can understand is just incredible. And this definitely will become one of my top formulae. So much potential!

[@garychadwick1240]

Fantastic tutorial thank you. I hadn’t even realised that Lambda had been added to Google Sheets. This is certain to be really useful. 👌🏻

[@marcobruni5402]

Finally LAMBDA became clear! Thanks a lot

[@ExcelGoogleSheets]

👍

[@vishaldoiphode07]

This is most precious day for me after watching this magical video You are the wonder in the world for me Lot of love ❤

[@jonathanlance2166]

After watching this video, one realizes how powerful spreadsheets have becomes since Lotus 123. Thanks.

[@davidsyes5970]

Loll I still use 1-2-3. Despite options out there, I kept coming back to 1-2-3. I like the GUI, colors, simplicity, low cognitive overload factor. But, it is lamentable that Lotus didn't get more areay functionality and more of LotusScript in the the grid, instead compelling users to learn LotusScript or hire contractors. Stuff I'm doing in 1-2-3 works there, but can be exported and largely used in other apps, if anyone is seriously intent.

[@hieulenhu1546]

Quá tuyệt vời. Nhờ video mà tôi hoàn thiện và hiểu sâu hơn về cách kết tạo hàm mới kết hợp Lambda. Cảm ởn rất nhiều.😍

[@melenev]

I was wodering when you were going to cover this for Google Sheets. Thanks for the video

[@SvedrikkGreyir]

This video, a masterclass in story telling😭. This video had better payoff than Lord of the Rings. Brought me to tears when he named the function MLOOKUP(world-shattered). This is my favorite video of the 2024

[@SvedrikkGreyir]

This guy gets it 💯

[@Avi8053]

You busted my fer for Lamdas! God bless you 🙏

[@carsonc1272]

Very cool, and very helpful. Thanks!

[@sheyanran508]

Excellent tutorial as always. Thank you! ❤️❤️❤️

[@ExcelGoogleSheets]

👍

[@xjarius]

Yessss so excited for this! Thank you!

[@leebecker8255]

Brilliant explanation. I love your tutorials 😍😍

[@antoniovijande]

Great video!!!

[@bang-naim]

Can't wait for you to cover all the lambda and its derivatives functions!!

[@ExcelGoogleSheets]

I've already covered them months ago.

[@bang-naim]

@@ExcelGoogleSheets gonna check them out, thank you!

[@jorgerios5977]

This is great. Thank you so much!!

[@teigenxayden]

you are so great,thankx for your share!

[@gbganalyst]

Thank you so much for this video. Please is there a way to wrap this MLOOKUP() into an array formula so that the LOOKUP_VALUE can be an array instead of just a cell? For example: =ArrayFormula(MLOOKUP(A2:A28, tisue!C2:C44,tisue!B2:B44)) This populates across the row instead of a column. = LAMBDA(lookup_value, lookup_array, return_array, TEXTJOIN("; " , TRUE, FILTER(return_array, lookup_array = lookup_value)))(lookup_value, lookup_array, return_array) Please help!

[@ExcelGoogleSheets]

Use MAP function kzbin.info/www/bejne/gIq1fo1mZbydnbM

[@mdrumi629]

Sir, as some new functions has been added into Google Sheets, is there any work around for using Arrayformula with Textjoin or Index function to get rid of the dragging formula down like the case in this video?

[@Lemms72]

@md rumi, shure. You use the MAP Function. there is also a video on this channel: "Advanced Array Formulas in Google Sheets & Excel"

[@aashitgarodia]

Hi, can you pease help me with an ARRAYFORMULA of this formula ? I know you mentioned already in comments using MAP but still can't figure it out.

[@JohnDeir]

Nice video/tutorial! Their are functions I keep forgetting and just made one: LAST_CELL_VALUE. index(L54:L,Match(100^100,L54:L) where the column is named Range . Doesn't seem like much but it is easier for me to remember this way. Thanks a bunch and I would like to see more strung together and odd ball functions.

[@TopBam]

The best last cell value: =LOOKUP( 2, 1/range, range )

[@GM085]

In Google Sheets, you don't need to use Lambda in the Formula Definition box. You could have just put everything after IFERROR and deleted the last parenthetical.

[@bloodyping9644]

Was just about to say that lol.

[@ExcelGoogleSheets]

👍

[@john1802]

Great tutorial. Thank you very much

[@lpanebr]

Could you get lambda functions to work with ArrayFormula? I don't think they do.. 😞

[@ExcelGoogleSheets]

The short answer is yes, but not the way you're used to.

[@lpanebr]

@@ExcelGoogleSheets intriguing! 🤔

[@ExcelGoogleSheets]

Check out MAP function kzbin.info/www/bejne/gIq1fo1mZbydnbM

[@tridsonline]

👍🏻 Excellent explanation, thanks. Can't wait to try this on my android! UPDATE: Nope, Google has withheld the definition of Named Ranges and Named Functions .. _from its android app users!_ 😢😡 Let's go Gurgle

[@GeorgePlaten]

Nice

[@rogeliotorres1045]

Thanks a lot

[@dracofrank2]

Will they work when you download as excel sheet?

[@aashitgarodia]

Is there any playlist for all the new functions released ?

[@ExcelGoogleSheets]

I'd start by watching these kzbin.info/aero/PLv9Pf9aNgemvXxLZfObnb3cvcG6gerfOB

[@ramneeksharma4226]

Please cover Scan, sortn function in google sheets

[@ExcelGoogleSheets]

OK

[@Manikandan-re8hy]

Hi, am using office 365 and MLOOKUP formula not available in my excel workbook/sheet. how to get it

[@ExcelGoogleSheets]

Watch the video? :)

[@TopBam]

Yep

[@Vandalfoe]

I'm surprised at how much Google Sheets is like Microsoft Excel.

[@iiiiii-w8h]

you cant use lambda if you're not sure if everyone you're working with has some of the latest versions of excel.

[@ExcelGoogleSheets]

Sure, but with that logic you can't use many things. There was no SUMIFS in 2003. There was no NETWORKDAYS.INTL in 2007. There was no IFNA in 2010. There was no IFS in 2016. There was no FILTER function in 2019.