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
@bskrmusic3932
2 жыл бұрын
Sir, Please share Advance excel link ..🙏🙏
@aishwaryasingamala3760
2 жыл бұрын
Sir,can u say about best website for excel mcqs
@Oluwagbeoyemiga
Жыл бұрын
@TrumpExcel, what is the formula if it's "150 miles" and we want the numbers? What about the space in between? Thanks
@sallyho146
Жыл бұрын
Hi TrumpExcel, Where is your via code?
@nawjuliasimons6022
Жыл бұрын
Thank you so much Sir. We found the solution that has been seeking for days.
@blackout995
Жыл бұрын
No BS. Explanations are crystal clear. Multiple solutions proposed. 10/10 video, you get a like and a sub.
@trumpexcel
Жыл бұрын
Glad you found the video useful 🙂
@TalmadgesArcade
11 ай бұрын
My hero. Hit like 5 other sites trying to do a special split. Lots of crazy over complicated foruimlas that wouldn't work for me. This guy, this guy gets it! THANK YOU! it took me 20 seconds to teach flash fill and bam, my list is spit.
@frankabacus7375
2 жыл бұрын
One of my favourite Excel master - explanations are clear and practice file attached. Thank you so much
@anthonylandrum63
Жыл бұрын
Flash Fill, OMG, that was cool. I have 69,682 rows, you saved me a lot of work!!!! Thank you. Happy New Years!
@athena1649
2 жыл бұрын
THANK YOU SO MUCH FOR THE FLASH FILL EXPLANATION! You have no idea how happy I am right now!
@keithbray6026
Жыл бұрын
Amazing!! This saved me so much time in my new job. Thank you 🙏
@trumpexcel
Жыл бұрын
Glad it helped 😊
@usmanalimuddin8139
2 жыл бұрын
MAGIC !!! I have been using left right formula for the years- this is something I can use it if the pattern in cells are different -Bravo
@74mili
11 ай бұрын
the first technique was exactly what i needed, it did 95% of the work just gotta check a few
@IvanCortinas_ES
2 жыл бұрын
Excellent treatment of these cases Sumit. They are highly requested examples by companies. Thank you very much for this great video.
@trumpexcel
2 жыл бұрын
Thanks Ivan... Glad you found the video useful :)
@NEG0POS
Ай бұрын
Fantastick! Love your explanation ... Thank You ...
@thulisilegumede8060
2 ай бұрын
Thank you very much saved me from spending hours to minutes 🤛
@دراساتاجتماعية-ز9ل
2 жыл бұрын
you are always glamorous
@SirShehu
Жыл бұрын
Thanks man, you saved me lots of work today
@frachiar4444
2 жыл бұрын
11 / 5.000 I point out that in my excel 2016 I must press Ctrl+Shift+Enter in order to have the result, but it works. Great!! 🙂 Thank you!!
@jahiduddin4745
Жыл бұрын
You just save my Day .Thak you So much .
@team-apricot
Жыл бұрын
Formula worked perfectly. Thank you
@trumpexcel
Жыл бұрын
Glad the video helped :)
@firasath
2 жыл бұрын
You are genius brother, I love your videos. Very informative, simple and to the point.👍
@trumpexcel
2 жыл бұрын
Thanks... Glad you found the video useful :)
@shiffamohammed5818
2 жыл бұрын
Thanks a lot Sumit, for the awesome excel tricks you shared.
@trumpexcel
2 жыл бұрын
Thanks... Glad you found the video useful :)
@StacyBrown2
Жыл бұрын
Your channel is the BEST!!
@joshuamanampiu6489
4 ай бұрын
Power query is my favourite. Thank you so much
@dgitson
2 жыл бұрын
This is a a great demonstration of alternative techniques, thanks.
@trumpexcel
2 жыл бұрын
Thanks... Glad you found the video useful :)
@jennerin-u9r
2 жыл бұрын
thank you so much. This saves me a lot of time and effort
@cespenaplata3498
Жыл бұрын
Thankyou so much it makes my work easier
@tunaikinyanguk5493
2 жыл бұрын
great as always. formula FIND({0,1,2,3,4,5,6,7,8,9} may alternatively be expressed as FIND(SEQUENCE(,10,0) in excel 365
@trumpexcel
2 жыл бұрын
Thanks for sharing :)
@HowToAnalyst
2 жыл бұрын
Thank you Sumit! I'm using method #2 with a formula.
@mohammadalbizri2013
2 жыл бұрын
Thankful, hope giving more lessons about power query
@MohAboAbdo
2 жыл бұрын
Thank you so mutch, Sir.
@mohamedelgamal6333
Жыл бұрын
Many Thanks for this great video. You are the best in this carear.
@muhammadyounis2686
2 жыл бұрын
Good info 👍 bro Love from Karachi 🇵🇰
@123mailashish
2 жыл бұрын
Well done.
@JayKhona
2 жыл бұрын
Was about to type in 73 rows to seperate them! Thank you
@mathewngure4358
Жыл бұрын
You are awesome, I learn a lot from you.
@athemkashung8266
6 ай бұрын
Excellent and useful. Thanks.
@trumpexcel
6 ай бұрын
Glad you found the video helpful 🙂
@sukhwinderpal1221
2 жыл бұрын
Very useful... Thnx for your effortful video👍👍
@sirajthalassery
2 жыл бұрын
Wow great.., Sumit I just started watch your channel recently. I am very pleased to say that your explanation is so clear and your teaching method is very interesting. Really I love it. waiting for your next videos eagerly. ThanX a lot Sumit ji.
@trumpexcel
2 жыл бұрын
Thanks Siraj... Glad you're finding the videos helpful :)
@maithilvivek6012
Жыл бұрын
YOUR FILE HELPED ME
@venusmarieampoloquio1023
Жыл бұрын
Thank You for this! Very helpful! 😊 easy to follow! ❤❤❤
@childrenhospitalfaisalabad2444
2 жыл бұрын
Very Very Helpful Thanks alot
@Sooraj-Rao6
Жыл бұрын
Thank you,video was simple and Helpful 👍
@ITH-g6p
Жыл бұрын
Thanks for uploading this, very helpful!
@johnfiott
2 жыл бұрын
Quite good. Really enjoyed the lesson.
@trumpexcel
2 жыл бұрын
Thanks John... Glad you found the video useful :)
@MichaelInEast
Жыл бұрын
Thanks! you are the best!!!
@ArunKumar_237
Жыл бұрын
you are genius 👍👍
@ezmakeswa3601
2 жыл бұрын
Hi Sumit you're great and I love your videos😊
@techkdeva8587
2 жыл бұрын
Very much useful video sir.Thank you
@tedmoy
2 жыл бұрын
Love these easy to follow instructions
@Jaime-c9l
2 ай бұрын
Thank you, thank you!!!! 😊
@luckytiwari2664
Жыл бұрын
LOVE IT THANK YOU VERY MUCH
@cinesnapshot-entertainment
6 ай бұрын
Excellent work
@trumpexcel
6 ай бұрын
Glad you found it helpful 🙂
@wayneedmondson1065
2 жыл бұрын
Nice one Sumit! Lots of use cases for these techniques. Thanks for demonstrating. Sometimes I have to extract numbers that are mixed with text. I use this formula: =--TEXTJOIN("",TRUE,FILTER(MID(A2,SEQUENCE(LEN(A2)),1),ISNUMBER(--MID(A2,SEQUENCE(LEN(A2)),1)))) which pulls out all the numbers from left to right as a single numerical value. Not always the desired goal, but when needed, it is useful. Requires Office 365 for dynamic array functions. Thanks for sharing your tips! Always useful and interesting :)) Thumbs up!!
@trumpexcel
2 жыл бұрын
Thanks for sharing Wayne :)
@akhilthomas6142
Жыл бұрын
Thanks It was great
@AsifAli-wq6oe
7 ай бұрын
Super Useful..Thanks
@trumpexcel
7 ай бұрын
Welcome... Glad you found the video helpful 😊
@sameerzulfisyed
Жыл бұрын
great job man. Thanks for the help
@sptsabharwals7202
Жыл бұрын
Thank you.
@Strawberry20246
2 жыл бұрын
Thanks for the video!
@MGAYEN733
2 ай бұрын
Excellent !!!
@manuaum2002
2 жыл бұрын
Excellent
@rohithkodasgolli9175
3 ай бұрын
Thank you sir.
@malikamjad1103
Жыл бұрын
This Is very good video sir keep it up
@umerrehmanaca2783
Жыл бұрын
Good one.
@AvnishKumar-ku3fc
Жыл бұрын
Thanks for guide😊
@conradpereira
2 жыл бұрын
Champion!!!! 😁
@Daku_ff98
2 жыл бұрын
Your videos are awesome. Have learned a lot from them 👍
@JohnSnow32
2 жыл бұрын
Very very good video
@daiyantasl
11 ай бұрын
THNX A LOT.
@stephanieabdul8860
Жыл бұрын
Thank you!!
@raphaelpavan6540
2 жыл бұрын
Wow, amazing. Thanksss
@tonianty
11 ай бұрын
please amend this formula with a negative numbers and decimals too. Thank you its really useful
@mammothcat2491
2 жыл бұрын
Nice and clear presentation. How about reverse as numbers and letter [175MKT]... Thanks
@hvijay7059
2 жыл бұрын
Nice tutorial sir
@ahmedmokhtar190
2 жыл бұрын
Really i enjoy this one thanks I ask about How to make current account statement thanks
@Hemivrma009
2 жыл бұрын
Got to know about this channel in Lallan top
@Mueez_OP_AmmaFoundationkhan
3 ай бұрын
Thanks bhai
@aravinthrv4787
2 жыл бұрын
we need an expert in excel works, will you able to work as a free lancer for specific projects
@preeshaprinson8828
11 ай бұрын
Thanksssss
@arunajambunathan7680
2 жыл бұрын
Hi Sumit, this is awesome. Please explain how to enable power query in Excel on Mac
@Herukamahesh
Жыл бұрын
That's a deal 👍
@knowledgewithhasu4716
2 жыл бұрын
Sir, ek video banaiye Tax invoice me quantity and rate jo 12 % tax lag raha hai (above 1000 rate) to convert kare ke quantity and rate 5% me (under 1000 rate) quantity increase kar ke per taxable value same karke excel me format kese banaiye
@sufiyansarankhawala6158
Жыл бұрын
Sir , how to seprate chq no. With starting with '0' in separate colume
@rajeevgosavi4514
2 жыл бұрын
Very useful video, found the info very relevant . Thank you Sumitji. Could you also please clarify if we need to save this file as macro enabled file.and what if we need to apply this VBA code across all the workbooks.
@praveen5183
Жыл бұрын
Any idea how to do subtraction and addition between alphabets
@SuperStone33
Жыл бұрын
This is very useful. thank you! but how about the numbers is like " 313 .60" this, how could we seperate by the VBA? I found that the VBA ignored the . thank you
@balajimallela333
2 жыл бұрын
Please make some more videos on Excel VBA
@TY-zl1vw
Жыл бұрын
Nice tip for passing multiple values via array for the find_text parameter of FIND function in the Formula approach. on my version of Excel, need to Shift Ctrl Enter to get it to work. It would be trickier if there are also more text after the Number). Is there a good Formula approach not too long also?
@priteshjain1627
2 жыл бұрын
Hi Sumit, wonderful methods, just wanted to check the VBA version whenever i enter the get text or number it shows as #NAME unable to rectify
@Marquetica
Жыл бұрын
I think I dont know how to do it lol. I have this text: "bohomodern wall minimalist; Search volume: 219, Competition: 1814". I need to extract 219 into one cell and 1814 into another one. I ned to apply it for the whole page. How do it do it? :D
@fd4483
Жыл бұрын
when I go to split option in power query it only shows split my delimiter and by number of character. Other options are not available i.e. by digit to non digit etc. My data consist in 1 row and contain alphabets and numbers same format as yours. Kindly help!
@Leddb1951
2 жыл бұрын
Lovely, as usual. But I can't get it to work when I put the code in my "personal.xlsb" and try to call the function from an Excel workbook (.xlsx). Work nice if the code is in a module of the same workbook.
@trumpexcel
2 жыл бұрын
When a function is saved in the Personal macro workbook, you need to use =PERSONAL.XLSB!GetNumber(A2). So before the function name, add =PERSONAL.XLSB!
@arunssairam
2 жыл бұрын
Sir, could you please tell me how to save this code as custom tab in excel
@guhankalimuthu598
2 жыл бұрын
Sir , please upload that time calculation sheet tutorials by explaining briefly .
@byabangdada2808
Жыл бұрын
F-1 (1.2X2.1X0.5) sir agar humme sirf bracket ke under wala number ko teen seperate column mein Lana chahta hai toh usko kese kare
@rlnsimha
2 жыл бұрын
I have a Sheet having all the records related to equipment's 2nd sheet i want to create a record based a user criteria with assignment (Means he will select the equipment then it will create a new row like that) In the same sheet again if user search based on the criteria he will select equipment then create new record This is near to inventory management , but inventory management not providing the history assignment. so i am expecting like this. How can I achieve this ? Could you suggest on this ? (Don`t recommend macro or vba because it is excel on web)
@fahadmaqboolsoomro
2 жыл бұрын
If you can kindly help me out in these two situations 1. I want results in C2 = late where A2 is late and B2 is early and C2=early where A2 is on time and B2 is early 2. I have products in columns and their ingredients in rows, I want a pop up form or table or anything alike that show me ingredients only related to product that I select like if I select cake then the ingredients of cake show up in next cells Please help me out Thanks and regards
@sabduljabbar5026
2 жыл бұрын
Sir How to have monthly and cumulative data row wise instead of columns using pivot table if we have one years data as raw data. In row 1 i want to have month data and in row 2 cumulative data.
@Rajeshgodsown
2 жыл бұрын
I am using Excel 2019. It demands CONTROL + SHIFT + ENTER, for this formula.
@ramoncaballero9319
Жыл бұрын
can anyone tell me how to fix my .xlsx format or apps which has two menus showing up, the upper which is functional but grayed out Review Tab of which tracking option I am interested to function or study how it works. The lower menu shows several chosen icons if any one of them is clicked, the whole worksheet crashes including the rest of the worksheets currently opened.
@sauarbh1985
2 жыл бұрын
which version you are using.. i am not getting all the options in split column in power query
@genetresom2380
2 жыл бұрын
I have a question, Sir. Is there any way to sum numbers only that include dates on the same row? like this, the data is from A2 up to J2. A2 is the amount of money, B2 is the payment day, C2 amount paid, D2 payment day. At last, there should be the total amount paid throughout the year. So when I drag all it will sum up the date too. Is there any way to ignore the date and sum only the amount paid, Sir?
@arunssairam
2 жыл бұрын
Sir, could you please tell me how to save this code as custom tab in excel
@learnwithqazisharifullah6753
2 жыл бұрын
dear I have excel 2019 but Unique function is not support. kindly help
@hassalmua1691
2 жыл бұрын
Still getting #VALUE after doing the second method (formula). I get 4 after pressing F9
Пікірлер: 155