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
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.
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!
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
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.
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.
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.
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 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!
@@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
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
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.
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
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.
Very nice video. Such coaching should be done at the school level.
Best wishes from Mumbai.
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!
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
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.
You saved my life today with that trick. Very thank you.
Thanks for your help. I did it effortlessly. Thankyou so much! Keep up the good work! 💪👍🏻
Thanks for this tutorial.
Was using Goto... Since long..
But from now, VBA code would be superhandy ..
Thank you once again for sharing 🥂.🤘
I am highly of your opinion
Great video and thanks for getting right into the meat of the issue!
OMG!! THIS IS what I have been looking for!!! THANK YOU !!!
Hi Sumit. Great to see a couple of ways of solving that problem! Thanks for sharing :)) Thumbs up!!
Hi Sumit, this is so easy , Thank you so much for sharing.
Thanks! Mate - this so helpful in data sanitisation you saved hours of mine.
Love all of them, Power Query is my favorite.
Thank you for this!
I have been looking for it earlier!
SUBSCRIBED!❤
It's very informative and explained very clearly
Thanks, I need more on how to do in online excel.
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.
Thanks for commenting Christie... Glad you found the video useful!
Great tutorial Sumit! Thank you for your explanation!
Thanks for commenting Iván... Glad you found the video useful!
Thank you Sumit. I enjoy your tutorials 😊
Thanks for commenting Nader... Glad you found the video useful!
Very nice video. Very effective code for this purpose. Thank you so much
very helpfull techniques
Thank you! very helpful
Thanks, that really helped me out today!
This is really cool way to work in excel
Thank you. It helped me a lot today
Very good explanation 👍
Very good information thanks
Thanks for commenting... Glad you found the video useful!
You're amazing! A power house of Excel knowledge. Thank you.
Hi Sumit,
Thanks for sharing, it was really helpful.
Subscibed and Thumbs up 👍
Nice learning 👍
Thank you so much...this is very useful.
Very Interseting & simple
Thanks a lot
Thank you so much this was amazing!
Thank you very much.
Very Nice,
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.
Brilliant THANKS!
This simply Excellent
thanks! I really like your videos
Very useful
woow very important. thanks
thank you very much!
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....
Thank you.
Amazing!
Thanks for sharing . Can you pls share link for tutorials on power query
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
Very useful lecture.
Thank you sir.
I liked power query method
Hi Sumit. Do you have a tutorial on how to use the IF OR Function?
Nice sir
Perfect
Awsome!
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
Need data
@@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!
Super
dude could you please do more improvised complex formulas and power queries please?
Yeah... Planning to create more formula videos. I also have a full Power Query course as a playlist that you can check out
@@trumpexcel how about a full VBA tutorial? like the way you explain with ease
@@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
@@trumpexcel thanks bro
Awesome
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
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.
Nice
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.
you can also open go to dialog box by pressing ctrl + g.
i used the first way to fill but after pressing ctr+enter i getting error of =b7 ...can you explian me
Loan pay back optimizer format can be available in excel?
Multiple loan repayment plan ? Pl share excel file
Multiple person how can maintenance?
How can I say? Really very useful
Glad you found the video useful!
How can we connect for 1 on 1 discussion??
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+[ .
You are using Excel 365 ?
Yes
I am getting error as 'No cells were found'
Bro it's not working on my file.
Thanks all
I want to change the last 2 digit in a coloumn 12345
12356 like this in a columns
👍
Hi Sumit, i have a query sent you a mail.
Replied to the email
@@trumpexcel Thanks Sumit shared in mail
Not working
I have some query could you please solve it.
Just share your mail Id so that I may send there my query Please.
Thank you!
Super
Glad you found the video useful!