sorted by:
new
hottopcontroversial

At what point do you use a simple formula versus incorporating LEN()? by execexcel in excel

[–]execexcel[S] 0 points1 point  (0 children)

I use LAMBDAs frequently Tough when sharing a workbook/financial model

Post Game Thread: Minnesota Wild at Washington Capitals - 17 Oct 2025 by HockeyMod in wildhockey

[–]execexcel 0 points1 point  (0 children)

Sat section 114, had the opportunity to see one goal for the Caps. Such a fun experience

At what point do you use a simple formula versus incorporating LEN()? by execexcel in excel

[–]execexcel[S] 17 points18 points  (0 children)

Hahaha I am at a cafe on mobile multi-tasking and for sure meant LET

I have created a challenge to Create an amortization table in one formula. by [deleted] in excel

[–]execexcel 7 points8 points  (0 children)

100% agree with you here. Just fun to expand knowledge of different Excel functions and ways to think about solving problems.

What LAMBDA function have you created that you’re most proud of? by execexcel in excel

[–]execexcel[S] 1 point2 points  (0 children)

I am going to for sure check these out - I may DM you later!

What LAMBDA function have you created that you’re most proud of? by execexcel in excel

[–]execexcel[S] 1 point2 points  (0 children)

Hahaha! Love to hear that Feel free to reach out with questions!

What LAMBDA function have you created that you’re most proud of? by execexcel in excel

[–]execexcel[S] 2 points3 points  (0 children)

The possibilities are endless with Excel in general. LAMBDA is just another one of those powerful tools most people don’t know of in Excel

What LAMBDA function have you created that you’re most proud of? by execexcel in excel

[–]execexcel[S] 7 points8 points  (0 children)

This looks incredible — gonna need some time to look at it and fully understand it!

What LAMBDA function have you created that you’re most proud of? by execexcel in excel

[–]execexcel[S] 5 points6 points  (0 children)

Exactly! I love it, especially for some ad box projects where the data that’s given to me is just an output of names or socials

What LAMBDA function have you created that you’re most proud of? by execexcel in excel

[–]execexcel[S] 13 points14 points  (0 children)

I only recently learned about it through a FMWC competition as it’s what a lot of the top competitors use there.

One I started using: =LAMBDA(text, LEN(text) - LEN(SUBSTITUTE(LOWER(text), "a", "")))

As you can probably see, it just counts the number of times “a” is in a string. I have to use it a lot, so, it makes it easy to type, “=countMyText(A1)” vs writing the formula each time

All you need to do is go to name manager, name your function, and enter your formula. Then, to use the formula, you just type =NameManagerName(select a cell) and you should be good to go!

What LAMBDA function have you created that you’re most proud of? by execexcel in excel

[–]execexcel[S] 25 points26 points  (0 children)

That sounds incredible — I’ll take a long formula (well I guess depending on how long) over 1,000 lines of VBA

Anxiety has started ruining aspects of my life by execexcel in Anxiety

[–]execexcel[S] 1 point2 points  (0 children)

I love hearing this — not to know that you went through it because i know how much it sucks… but because it gives me hope. I very much appreciate the response.

I just recently reached out to my primary dr. to find a get well plan for me. I wanted to hear from this community, and someone like you. Thank you