MS Excel - TEXTJOIN & IF Function | Excel Function

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

КОМЕНТАРІ • 39

  • @Yodalearning
    @Yodalearning  4 роки тому

    Increase your productivity with our all New Microsoft Excel 2019 and Office 365 features Online Course
    Enroll Now: bit.ly/3dHZaDv

  • @ogunronbitaiwofisayo6085
    @ogunronbitaiwofisayo6085 Місяць тому

    Thank you for this. An alternative would be using the concat/text join and the filter function.

  • @skmaheswaran
    @skmaheswaran 2 роки тому

    You have explained the TEXTJOIN in a simple way with an nice example.

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

    You have saved me sir 🤝

  • @RohanDixit-sy6oh
    @RohanDixit-sy6oh Рік тому

    This was really helpful. I had one question if instead of 'Domain Expertise' if there are various timings mentioned and we want to calculate duration of those how can we do that?

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

    Jahapana .... You made my day..

  • @msangelinejoe
    @msangelinejoe 3 роки тому

    Amazing I need this, however what if the data needed are in another sheet, and the collumns (Emp ID & Domain Expertise) are far apart? Thank you

  • @kalimanx
    @kalimanx 2 роки тому

    Great explanation. I'm very grateful. Thank you.

  • @surkaranful
    @surkaranful 4 роки тому

    Excellent man. Wonderfully explained. This is what I wanted to learn since long time ago but didn’t know what’s the function for this technique,, appreciate your work

    • @Yodalearning
      @Yodalearning  4 роки тому +1

      Our pleasure Karan! Keep learning...

  • @apn6824
    @apn6824 4 роки тому

    Beautiful explanation Rishab...Really a new thing we learnt...God bless you.

  • @hyukshin2387
    @hyukshin2387 2 роки тому

    Loved the explanation. Helped greatly

  • @tariqzk6964
    @tariqzk6964 4 місяці тому

    you are the best

  • @majohar94
    @majohar94 3 роки тому

    what's the solution for 2013 excel? by the way thank you so much for the valuable information

  • @Passion4Fashion2023
    @Passion4Fashion2023 2 роки тому

    Loved it. Thank you.

  • @judithvalentine8931
    @judithvalentine8931 2 роки тому

    Thank you so much for this video

  • @anirudhbankapur5384
    @anirudhbankapur5384 4 роки тому

    Thanks! One clarification, how to get multiple employees names entered in single cell into different rows?

  • @kanaali1626
    @kanaali1626 2 місяці тому

    thank you

  • @j.ontrack
    @j.ontrack 11 місяців тому

    you save my life

  • @kedarkulkarin78
    @kedarkulkarin78 4 роки тому

    Could have used table and # based range construct to make it more dynamic.

  • @rajarajan8951
    @rajarajan8951 4 роки тому

    Superb explanation ..

  • @pintukhan5064
    @pintukhan5064 2 роки тому

    Perfect💯

  • @zohurulislam7628
    @zohurulislam7628 4 роки тому

    Excellent video boss

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

    It's amazing

  • @abidg1597
    @abidg1597 4 роки тому

    Pls make detailed video on xlook up. Thanks

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

    how about two condition?

  • @apparaodevarapalli3287
    @apparaodevarapalli3287 4 роки тому

    Excellent sir

  • @seaalbahr2404
    @seaalbahr2404 4 роки тому

    Thanks

  • @thepunjabi1
    @thepunjabi1 3 роки тому

    Sir its not working in wps

  • @sandipguin94
    @sandipguin94 4 місяці тому

    Not working😢

  • @angeleyes6395
    @angeleyes6395 4 роки тому

    *Yoda Learning - Excel, Excel VBA and Power BI* Awesome vid. If you had One wish. what Would it be? let's build each other up xd