No video

Custom functions don't have to be hard to be helpful!

  Рет қаралды 1,427

Diarmuid Early

Diarmuid Early

Күн бұрын

This video walks through writing your first custom function in Excel using the LAMBDA function.
It's part of a (still growing) series - you can find the whole playlist here:
• Write your own functio...

Пікірлер: 12
@deepakdalal4580
@deepakdalal4580 Ай бұрын
Look forward to this series as we get more n more complex and complicated Lambdas. Thank you
@45rewy28
@45rewy28 Ай бұрын
Another amazing, super informative video - appreciate it, as always!
@MagicOfMushrooms
@MagicOfMushrooms Ай бұрын
Great stuff!
@abdecerrone6609
@abdecerrone6609 Ай бұрын
So much thanks for this video
@sledgehammer-productions
@sledgehammer-productions Ай бұрын
it seems like sum(range1*range2) gives the same output as sumproduct(range1;range2), didn't know that! copying the lambda function to another workbook takes care of the "NamedRange". I'm already less intimidated. Thank you for so clearly explaining this.
@DimEarly
@DimEarly Ай бұрын
Yes, I almost never use SUMPRODUCT anymore (almost because old habits die hard!). Although it’s good to remember if you need backward compatibility. And I’m glad to hear it made it less intimidating!
@christoslefkimiotis9889
@christoslefkimiotis9889 Ай бұрын
Hi I am trying to write a lambda function to calculate the margin of a debt, based on a specific leverage ratio, so I am trying to find a lambda to avoid circularity...Hope you continue this series of videos.
@soledeze
@soledeze Ай бұрын
Thanks. Am looking forward to next in the series! I am less intimidated and ready to practice LAMBDA.
@redchakra03
@redchakra03 Ай бұрын
Can't wait to see more of those LAMBDA!
@akidasharif2701
@akidasharif2701 Ай бұрын
Thanks Diarmund, keep them coming
@daviddleon9127
@daviddleon9127 Ай бұрын
Hello 👋 😅
@DimEarly
@DimEarly Ай бұрын
👋🏻
The surprising value of a function that does nothing
17:14
Diarmuid Early
Рет қаралды 2,1 М.
Write your own Excel functions
19:22
Diarmuid Early
Рет қаралды 2 М.
КАКУЮ ДВЕРЬ ВЫБРАТЬ? 😂 #Shorts
00:45
НУБАСТЕР
Рет қаралды 3,3 МЛН
Meet the one boy from the Ronaldo edit in India
00:30
Younes Zarou
Рет қаралды 17 МЛН
How to solve Michael Jarman's latest crazy case
39:07
Diarmuid Early
Рет қаралды 1,4 М.
A top e-sports competitor shares her secrets!
40:12
Diarmuid Early
Рет қаралды 1,1 М.
Get started with Regex (in Excel)
23:15
Diarmuid Early
Рет қаралды 7 М.
Write Excel formulas like a programmer
18:15
Diarmuid Early
Рет қаралды 6 М.
How to use the Excel MAP and REDUCE functions
15:37
Diarmuid Early
Рет қаралды 2,5 М.
The moment we stopped understanding AI [AlexNet]
17:38
Welch Labs
Рет қаралды 947 М.
The World Depends on 60-Year-Old Code No One Knows Anymore
9:30
Coding with Dee
Рет қаралды 750 М.
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 497 М.
I forced EVERYONE to use Linux
22:59
NetworkChuck
Рет қаралды 435 М.
КАКУЮ ДВЕРЬ ВЫБРАТЬ? 😂 #Shorts
00:45
НУБАСТЕР
Рет қаралды 3,3 МЛН