Access Your Lambda Equations From Any New Excel Workbook

Поділитися
Вставка
  • Опубліковано 27 гру 2024

КОМЕНТАРІ • 7

  • @lewisshaw4421
    @lewisshaw4421 3 місяці тому

    Usefull on both tips, thanks

  • @Michael_Alaska
    @Michael_Alaska 6 місяців тому

    Nice. How could you bring the template lambda's into an existing Excel file?

  • @heshamfouad8886
    @heshamfouad8886 Рік тому

    Nice & Neat Approach, Thanks for Sharing
    And thanks for the bonus tip 🤓

    • @ExcelSmith
      @ExcelSmith  Рік тому

      Thanks. Glad you like it. 😀

  • @richardhay645
    @richardhay645 Рік тому +1

    This video is said to be a year or so old but I just ran across in the UA-cam feed. Template is a good approach but requires some "tricky" navigation. I find Autocorrect to be easier. (Avoid Name Manager completely.) Open the Replace/With dialog box. "Replace" is the short function abbreviation; "With" is the function (a LAMBDA or any functioin). This is available in all workbooks/sheets.

    • @ExcelSmith
      @ExcelSmith  Рік тому +1

      Thanks for the comment and for the alternate solution.

    • @educationplace-tutorials-c6401
      @educationplace-tutorials-c6401 Рік тому

      @richardhay645. That's a really interesting approach, but what if the formula contains a cell reference?