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

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 ❤

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

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!

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

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.

Finally LAMBDA became clear! Thanks a lot

@ExcelGoogleSheets

Жыл бұрын

👍

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

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

Yessss so excited for this! Thank you!

You busted my fer for Lamdas! God bless you 🙏

Very cool, and very helpful. Thanks!

This is great. Thank you so much!!

Brilliant explanation. I love your tutorials 😍😍

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

@ExcelGoogleSheets

Жыл бұрын

👍

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

@user-gs8vx7wg5l

4 ай бұрын

This guy gets it 💯

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!

👍🏻 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

Stupendous!

@ExcelGoogleSheets

Жыл бұрын

Thank You!

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

10 ай бұрын

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

Thanks a lot

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 kzread.info/dash/bejne/fI2Gr7xpYLrQl7Q.html

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.

Great tutorial. Thank you very much

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"

Nice

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

Жыл бұрын

👍

Yep

Will they work when you download as excel sheet?

Is there any playlist for all the new functions released ?

@ExcelGoogleSheets

Жыл бұрын

I'd start by watching these kzread.info/head/PLv9Pf9aNgemvXxLZfObnb3cvcG6gerfOB

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

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

@ExcelGoogleSheets

Жыл бұрын

Watch the video? :)

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 kzread.info/dash/bejne/fI2Gr7xpYLrQl7Q.html

Please cover Scan, sortn function in google sheets

@ExcelGoogleSheets

Жыл бұрын

OK

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.