FILL DOWN Until Next Value in Excel (3 Really Easy Ways)

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

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

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

    If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
    Also, I have made all of my Excel courses available for free. You can check these out using the below links:
    ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
    ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
    ✅ Free VBA course - bit.ly/excel-vba-course
    ✅ Free Power Query Course - bit.ly/power-query-course

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

    You are a real brahmin, an excellent teacher. Straight to the point and exactly what I needed to know with no time wasted on ego stuff. Thank you, thank you, thank you. Truly excellent.

  • @yagneshbhatt8399
    @yagneshbhatt8399 3 года назад +6

    Very nice video. Such coaching should be done at the school level.
    Best wishes from Mumbai.

  • @lydiaarchuleta8247
    @lydiaarchuleta8247 5 месяцев назад

    Thank you, thank you, thank you!!! This is exactly what I was looking for!!! I had thousands of rows with blanks in between each cell that I needed to autofill down and you saved me hours of work!

  • @Prashant-vj5xq
    @Prashant-vj5xq 3 года назад +4

    This is so helpful, i happen to do this every week and was using ctrl+d for each set of cells. this will really save atleast 1 hour per week....Thanks a lot

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

    I have been watching and following your tutorial since subscription which are great for excel. God 🙏 bless you. I hope you will get million subscribers soon.

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

    You saved my life today with that trick. Very thank you.

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

    Thanks for your help. I did it effortlessly. Thankyou so much! Keep up the good work! 💪👍🏻

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

    Thanks for this tutorial.
    Was using Goto... Since long..
    But from now, VBA code would be superhandy ..
    Thank you once again for sharing 🥂.🤘

  • @sailing_life_
    @sailing_life_ 9 месяцев назад

    Great video and thanks for getting right into the meat of the issue!

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

    OMG!! THIS IS what I have been looking for!!! THANK YOU !!!

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

    Hi Sumit. Great to see a couple of ways of solving that problem! Thanks for sharing :)) Thumbs up!!

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

    Hi Sumit, this is so easy , Thank you so much for sharing.

  • @shivamsingh-iz6qc
    @shivamsingh-iz6qc 2 года назад

    Thanks! Mate - this so helpful in data sanitisation you saved hours of mine.

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

    Love all of them, Power Query is my favorite.

  • @MarvindeSalit
    @MarvindeSalit 3 месяца назад

    Thank you for this!
    I have been looking for it earlier!
    SUBSCRIBED!❤

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

    It's very informative and explained very clearly

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

    Thanks, I need more on how to do in online excel.

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

    Hi Sumit, Excellent presentations. I enjoy these very much although I do not work with EXCEL as much as I did in the past. Very clear and informative. Thanks for your efforts.

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

      Thanks for commenting Christie... Glad you found the video useful!

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

    Great tutorial Sumit! Thank you for your explanation!

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

      Thanks for commenting Iván... Glad you found the video useful!

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

    Thank you Sumit. I enjoy your tutorials 😊

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

      Thanks for commenting Nader... Glad you found the video useful!

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

    Very nice video. Very effective code for this purpose. Thank you so much

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

    very helpfull techniques

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

    Thank you! very helpful

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

    Thanks, that really helped me out today!

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

    This is really cool way to work in excel

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

    Thank you. It helped me a lot today

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

    Very good explanation 👍

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

    Very good information thanks

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

      Thanks for commenting... Glad you found the video useful!

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

    You're amazing! A power house of Excel knowledge. Thank you.

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

    Hi Sumit,
    Thanks for sharing, it was really helpful.
    Subscibed and Thumbs up 👍

  • @RajendraPatel.
    @RajendraPatel. 3 года назад +1

    Nice learning 👍

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

    Thank you so much...this is very useful.

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

    Very Interseting & simple

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

    Thanks a lot

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

    Thank you so much this was amazing!

  • @NazrulIslam-tx8ss
    @NazrulIslam-tx8ss 2 года назад

    Thank you very much.

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

    Very Nice,

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

    This was very good video. HOwever, when I tried to use Power Query to fill down the cell but the blank cells were not 'Null' but "error'. Do you know how to address this? Many thanks.

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

    Brilliant THANKS!

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

    This simply Excellent

  • @dianat.sandoval2561
    @dianat.sandoval2561 3 года назад +1

    thanks! I really like your videos

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

    Very useful

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

    woow very important. thanks

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

    thank you very much!

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

    Can you save that "VBA" code as an add-in... Or is that something different to a macro?
    Ver helpful.... For something I come across quite often....

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

    Thank you.

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

    Amazing!

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

    Thanks for sharing . Can you pls share link for tutorials on power query

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

      Thanks Shalabh... I have the link of the Free Power Query course in the description. Will put the link here when back on my system

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

    Very useful lecture.
    Thank you sir.

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

    I liked power query method

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

    Hi Sumit. Do you have a tutorial on how to use the IF OR Function?

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

    Nice sir

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

    Perfect

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

    Awsome!

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

    hi Sumit, I love your content, it's very helpful. I'd need help, though no idea where to find. I have multiple words in cells in one column. i have to find unique words and put them in one column. usually i do text-to-column and copy them into one column and removed duplicate. is there any easier way, do you have any material on this? thanks a lot, Reka

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

      Need data

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

      @@zohurulislam7628 A1 orange apple kiwi A2 lkjfdlsd pear apple A3 blueberry acai apple A4 none A5 pear
      same concept, much more text per cell, all in one column
      after text to column they spread out and then I have to put them back into one column B1 orange C1 apple D1 kiwi B2 lkjfdlsd C2 pear D2 apple B3 blueberry C3 acai D3 apple B4 none B5 pear
      so i need help to break the words into separate cells and line them into one column
      thanks a lot!

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

    Super

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

    dude could you please do more improvised complex formulas and power queries please?

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

      Yeah... Planning to create more formula videos. I also have a full Power Query course as a playlist that you can check out

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

      @@trumpexcel how about a full VBA tutorial? like the way you explain with ease

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

      @@wasilmufrat1728 Have a full VBA course as well. Here are links to all my courses (available on RUclips):
      ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
      ✅ Free VBA course - bit.ly/excel-vba-course
      ✅ Free Power Query Course - bit.ly/power-query-course

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

      @@trumpexcel thanks bro

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

    Awesome

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

    Nice. But how to remove filled data back to original. (Or) you will tell how to fill I need how remove like that data. Please help me best option for this

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

    Hi! I need your help.
    I created a button counter...
    I placed the activeX button on column C and everytime I click the button it will +1 value to column b. Now its working perfectly fine
    Now I have several buttons setup in the sheet and what I want to happen is the cell (column b)to highlight each time I click the button and adds a value.

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

    Nice

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

    And we can also do a simple step by just copy the cell and then paste it into the cells below by selecting with Ctrl + shift + ⬇️ key.

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

    you can also open go to dialog box by pressing ctrl + g.

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

    i used the first way to fill but after pressing ctr+enter i getting error of =b7 ...can you explian me

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

    Loan pay back optimizer format can be available in excel?
    Multiple loan repayment plan ? Pl share excel file
    Multiple person how can maintenance?

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

    How can I say? Really very useful

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

      Glad you found the video useful!

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

    How can we connect for 1 on 1 discussion??

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

    PLZ INFORM HOW TO CHANGE EXCEL SETTING FOR GO TO LINKED CELL DESTINATION BY USING MOUSE SINGLE CLICK INSTEAD OF USING KEY BOARD SHORT CUT CTRL+[ .

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

    You are using Excel 365 ?

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

    I am getting error as 'No cells were found'

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

    Bro it's not working on my file.

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

    Thanks all

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

    I want to change the last 2 digit in a coloumn 12345
    12356 like this in a columns

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

    👍

  • @cookwithab.aabidbeigh7068
    @cookwithab.aabidbeigh7068 3 года назад +1

    Hi Sumit, i have a query sent you a mail.

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

    Not working

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

    I have some query could you please solve it.
    Just share your mail Id so that I may send there my query Please.

  • @ericl.8893
    @ericl.8893 2 года назад

    Thank you!

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

    Super

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

      Glad you found the video useful!