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

Поделиться
HTML-код
  • Опубликовано: 24 авг 2024
  • 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 Месяц назад +1

    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 Месяц назад +3

    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 Месяц назад +1

    Hello 👋 😅