Пікірлер

  • @pradeepselvaratnam9459
    @pradeepselvaratnam94594 сағат бұрын

    👍👍

  • @scrumbaker
    @scrumbakerКүн бұрын

    Excel function = cool. How it applies to wage and hour law at federal and state and local level is debatable. Clear that it would rob employees of wages. Do not like.

  • @dietricwilliams3570
    @dietricwilliams3570Күн бұрын

    what if your data has column headers that are stacked on top of one another (for example YEAR | MONTH) then several repeating value attributes across columns???

  • @purvifandru6842
    @purvifandru68422 күн бұрын

    I want to learn any classes how to contact i m beginner

  • @tyegra6665
    @tyegra66653 күн бұрын

    Sir just a question, in the product codes you can type any numbers by random or they are specific? Im new to this, trying to figure it out

  • @kalaivanirangasamy24
    @kalaivanirangasamy244 күн бұрын

    For Text, ok But for numbers which formula Please tell me

  • @steventoral10
    @steventoral105 күн бұрын

    I don’t see the link

  • @rustamefendi9513
    @rustamefendi95135 күн бұрын

    Very good

  • @user-py5tc5bw1s
    @user-py5tc5bw1s6 күн бұрын

    What the Title name song ? Please tell me I love it . ❤❤

  • @reddy8861
    @reddy88617 күн бұрын

    I think you can also try with =TEXTSPLIT()

  • @user-rs8eg1zl6h
    @user-rs8eg1zl6h8 күн бұрын

    Who sawed Arnold shawarma 😂😂😂🤦🏻🤦🏻🤦🏻

  • @SimonMafuta
    @SimonMafuta9 күн бұрын

    Thanks

  • @usmanmustafaahmad
    @usmanmustafaahmad9 күн бұрын

    TOCOL FUNCTION IS NOT WORKING

  • @ronamyzacarias4110
    @ronamyzacarias411011 күн бұрын

    Will it work for table which has a lot of null?

  • @LearnExceltoexcel
    @LearnExceltoexcel11 күн бұрын

    As we will be using table address so shouldn't be a problem

  • @POPCORNTOONS
    @POPCORNTOONS11 күн бұрын

    what about half day

  • @LearnExceltoexcel
    @LearnExceltoexcel11 күн бұрын

    Check the solution done in excel here in the same channel.

  • @mayurkhedekar4441
    @mayurkhedekar444112 күн бұрын

    I don't have this filter formula in ky excel so what to do?

  • @LearnExceltoexcel
    @LearnExceltoexcel11 күн бұрын

    Power Query is the next best alternative

  • @prasadkumarkkalaburgi8556
    @prasadkumarkkalaburgi855613 күн бұрын

    Why do we lock the Range?

  • @TownHall16-je5du
    @TownHall16-je5du14 күн бұрын

    If and function also working

  • @miscvids6496
    @miscvids649617 күн бұрын

    No description no link for downloadeing the practice file???

  • @LearnExceltoexcel
    @LearnExceltoexcel16 күн бұрын

    Practice file is mentioned in the description of this video.

  • @miscvids6496
    @miscvids649617 күн бұрын

    No description no link for downloadeing the practice file???

  • @wanggang2396
    @wanggang239619 күн бұрын

    I really like your video and I would like to know how the two animations that are incorrect and correct are made in the video ✅❌

  • @DileepSingh-df9uo
    @DileepSingh-df9uo20 күн бұрын

    not showing filter function in ms-2019 can u give alternative

  • @tinaboro3118
    @tinaboro311821 күн бұрын

    Lol 😂

  • @Bhavik_Khatri
    @Bhavik_Khatri22 күн бұрын

    Nice little trick

  • @praveentiwari7283
    @praveentiwari728322 күн бұрын

    What happens if i need the last name?

  • @kodetrek4247
    @kodetrek424722 күн бұрын

    Excellent job!! Btw, did you make this video from phone or pc screen? Thanks

  • @azwb
    @azwb26 күн бұрын

    Here's it typed out--->. =ARRAYTOTEXT(SORT(TRIM(TEXTSPLIT(C3,",")),,1,TRUE))

  • @josephmw431
    @josephmw43127 күн бұрын

    Mine doesn't have filter function, what do I do?

  • @LearnExceltoexcel
    @LearnExceltoexcel26 күн бұрын

    Power Query is the next best option. FILTERXML is a function but a bit too clunky.

  • @Neonidas5652
    @Neonidas565228 күн бұрын

    How could you add multiple variables together on a data table like this? For instance if there was two Blake Dreary in the table, VLOOKUP only gives the first instance.

  • @LearnExceltoexcel
    @LearnExceltoexcel26 күн бұрын

    You can use conditional sum for this.

  • @user-th6hd9ik3s
    @user-th6hd9ik3s28 күн бұрын

    Vai tumne ekdam lojham lojh kardiya

  • @user-zf1fd2wz2v
    @user-zf1fd2wz2v29 күн бұрын

    If I had seen this yesterday...but thanks anyway🎉

  • @sanket565
    @sanket56529 күн бұрын

    How about vstack??

  • @JHatLpool
    @JHatLpoolАй бұрын

    Great quick demonstration. Thanks.

  • @meep12326
    @meep12326Ай бұрын

    Song name pls?

  • @tractorspotter7276
    @tractorspotter7276Ай бұрын

    this saved me thank you so much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  • @vikv4884
    @vikv4884Ай бұрын

    Don't play song, explain it. Pls ❤

  • @finaayuwardani
    @finaayuwardaniАй бұрын

    the F4 button doesn't work to lock the table. what should I do?

  • @Md.RazibulHossain
    @Md.RazibulHossainАй бұрын

    Is not working after downloading, can your please tell us how to save

  • @pankajdoor
    @pankajdoorАй бұрын

    HALF DAY HOGA TO KYA KARAINGEE😂😂

  • @shamsherkhan2700
    @shamsherkhan2700Ай бұрын

    Excellent 👌

  • @anhhoangminh9474
    @anhhoangminh9474Ай бұрын

    Good.

  • @mos3863
    @mos3863Ай бұрын

    Can you explain it what have you done in that formula

  • @mos3863
    @mos3863Ай бұрын

    Kindly provide the practice files

  • @LearnExceltoexcel
    @LearnExceltoexcelАй бұрын

    1drv.ms/x/s!Apno7889bCyLq3FoKFgLjOje8xcs?e=IVeg6U

  • @reyt.1967
    @reyt.1967Ай бұрын

    THANKS

  • @LearnExceltoexcel
    @LearnExceltoexcelАй бұрын

    🎉

  • @oghenefejiroagbi1469
    @oghenefejiroagbi1469Ай бұрын

    i tried the Concat, didnt work, but the "text join " command worked perfectly for numbers too