Excel LAMBDA Function - More Complex Examples

Поделиться
HTML-код
  • Опубликовано: 20 авг 2024

Комментарии • 28

  • @lcntrdm7618
    @lcntrdm7618 3 года назад +3

    Thanks for these great examples! Amazing as always! 😍

  • @RockLoi
    @RockLoi 3 года назад +1

    Awesome video, looking forward to playing with this a lot.
    Though parenthesee was a fun term to hear.

  • @syedaneesdurez8766
    @syedaneesdurez8766 Год назад

    Amazing.
    Appreciate if u can help to filter with multiple lists.
    Thank you

    • @SeleTraining
      @SeleTraining  Год назад

      ruclips.net/video/xwTUfU8PqCU/видео.html

  • @jahilbanda1540
    @jahilbanda1540 3 года назад +2

    thanks :o)

  • @ngozireyes1178
    @ngozireyes1178 3 года назад +1

    Thanks but I need more examples on this to understand it better

    • @SeleTraining
      @SeleTraining  3 года назад

      make sure to check out the first video on LAMBDA: ruclips.net/video/Ayc7QOadBa4/видео.html

  • @syedaneesdurez8766
    @syedaneesdurez8766 Год назад

    Looking for filter list dynamic arrays.
    In Range

    • @SeleTraining
      @SeleTraining  Год назад

      ruclips.net/video/xwTUfU8PqCU/видео.html

  • @jimihieu
    @jimihieu 3 года назад

    Can you show examples where it can pass a value from xlookup into lambda for calculation

    • @SeleTraining
      @SeleTraining  3 года назад

      I probably won't create a video for it but if you take some of the examples in this video you can envision how XLOOKUP would work. Just reference a parameter like x as an XLOOKUP function. This XLOOKUP video may help as well: ruclips.net/video/xxX8XiuKFEY/видео.html

  • @LeonGK59
    @LeonGK59 2 года назад

    Does this methode save computing power? That would be really interesting if that was the case..

    • @SeleTraining
      @SeleTraining  2 года назад +1

      I haven’t ran a comparison but LAMBDA uses native Excel language which may be faster than VBA or other solutions.

  • @submariner99
    @submariner99 2 года назад

    Have been using 365 for ages now but still not getting the LAMBDA function. When is it going to be available for general use?

    • @SeleTraining
      @SeleTraining  2 года назад +2

      Still no word from Microsoft. I think they’ve held it because additional functions are getting added that tie into LAMBDA. They may be waiting to test those out and release them all together.

  • @mikahamari5994
    @mikahamari5994 3 года назад

    I have 365, but this Lambda function is still not available even if I have installed all updates. It is frustrating to see, how useful this function is and not to be able to use it. This doesn't give good impression about the policy how Microsoft treat their customers.

    • @SeleTraining
      @SeleTraining  3 года назад +1

      It is still in beta. I have the beta installed as a test user so I see these features sooner. It should be coming soon.

    • @mikahamari5994
      @mikahamari5994 3 года назад

      @@SeleTraining Thank you for your answer. So, we outsiders are still waiting. If it helps the process that first the insiders test the functionality, maybe it is good in the long run.

  • @SlashchyninOleksandr
    @SlashchyninOleksandr 3 года назад

    Can it help to create a fifo formula?

    • @SeleTraining
      @SeleTraining  3 года назад

      Potentially. You can create a LAMBDA function based on any formula you want and you can pass a range of data as the parameter variables so it should work but I haven't worked through that process to confirm it.

  • @hakansokmen614
    @hakansokmen614 3 года назад

    HEY I HOPE YOU ALL KEEPING WELL, I NEED SOME HELP GUYS FOR MY WEEKLY TIME TABLE...
    EXAMPLE;
    FOR RAW,
    IF I PUT 1 ON B1 IS THERE ANYWAY EXCEL FILL THE REST FOR ME UNTIL H1...
    SO IF I PUT 1 ON B1 AND PRESS ENTER C1 APPEAR 2 D1 3 , E1 4, F1 5, G1 6 H1 7,
    AND SAME AGAIN IF I PUT 8 ON B1 AND EXCEL AUTOMATICALLY FILL THERE REST NUMBER FOR ME UNTIL 14.
    AND IF I PUT B1 15 AND SAME AGAIN FILL THE REST NUMBER FOR ME,
    I DONT KNOW IF THERE IS ANY FORMULA FOR THIS...
    HOPE YOU HELP ME...
    THANKS
    ....

    • @CLove511
      @CLove511 2 года назад

      Assuming you're always doing the same 7 cells, you can set C1's formula to "=B1+1" then drag it over to H1 with the fill handle. Save this worksheet as a template, and then whatever you type in B1 will auto-update the rest of the week, and you can use this for future weekly time tables.
      This will work with days of the month, as well as actual dates.

  • @darkfire1408
    @darkfire1408 2 года назад

    Anyone ever tell you you sound like the Technoblade of Excel Mastery?

    • @SeleTraining
      @SeleTraining  2 года назад +1

      Multiple times! But the reality is he sounds like me.