Brother you are a legend, thank you for this saved me days of struggle. Gave that man a Bells!!!!
@gvinodnair3 жыл бұрын
Appreciate your generosity as usual by sharing such gem of knowledge and information to the public.
@Cu_Ty_Pro2 жыл бұрын
Thanks man. Exactly what I needed. A tip for everyone that has a long list of things in a cell. Instead of just 1 or 2. And want to make a new line for each thing. Instead of [ "," ]=> replace with CHAR(10) Select the cell, choose Merge and Center on the Alighment section. Then Wrap Text. Everything should look good.
@WarriorsWay90 Жыл бұрын
Thank you so Much brother❤
@beckygonzalez52692 жыл бұрын
I praise my God for using you to show me how to find and join multiple results. I had been trying for several days and had been unsuccessful. Your teaching method is clear and leads to results. May God bless you and may you see His hand working in your life today. Sincerely, Becky
@frenan829 ай бұрын
I bookmarked this video and today save my day at work. Thanks... again and again
@q-breezy48263 жыл бұрын
This is pretty good, you may want to change the use of "IF" to "Filter" as I think that will be a little more straightforward and will probably perform better over larger data sets. You could also use the "SORT" formula around the unique if you wanted things in alphabetical order.
@MohammedRafee-yz1oo Жыл бұрын
this may cause data overwrite.
@ahmedalhady40288 ай бұрын
"Filter" won't bring the data in one cell
@q-breezy48268 ай бұрын
@@MohammedRafee-yz1oo I mean to replace the if formula which returns an array in this example with the filter formula that also returns array, in both instances a formula like text join will convert the array into a delimited string. Either works just fine, I just find the use of the filter formula a little simpler/easier to read/explain than the if. If some condition is true with this range return another range otherwise return nothing, vs filter all the values I want where my condition is true. For people that don't do formulas/logical conditions as much it's just a tad harder wrapping your head embedded if statements, however in this example they are both pretty close so either way is fine.
@q-breezy48268 ай бұрын
@@ahmedalhady4028 replied in another thread.
@deekshachauhan83383 жыл бұрын
You don't know what Importance you have in our lives thanku😊👍
@vsyamprasad3 жыл бұрын
Really u r great... i used to watch regularly many videos on excel, but u r a person who explain things in the right way and right quantum with quality... tq bro...
@trumpexcel3 жыл бұрын
Glad you're finding the videos useful!
@cacapsule1727 Жыл бұрын
What a man what a man .....superr mind blowing big fan of you sir
@amjeth3 жыл бұрын
Excellent! I'm happy that my logic of developing complex formulas from simple formulas are the same used by an expert like you as well...
@adityaverma7297 Жыл бұрын
You have saves a few days of my life by providing this formula.
@rhayes32812 жыл бұрын
I was trying to find a way to match multiple entries to a unique identifier and this is exactly what I needed to know. Thank you.
@adnanali39712 жыл бұрын
Appreciate your insights. The best thing is that you don't beg for "subscribe". Plz record videos in high volume as the volume is quite low. Thanks.
@joter-rificteacher83602 жыл бұрын
Thanks for this. It helped me a lot to solve my problem in writing remarks in the school form that has two conditions in one cell. God bless you.
@pfatalbert2 жыл бұрын
Thank you so much. I used this on a data set of over 100k rows and it worked perfectly. (I'm still not sure if I 100% understand and follow along, but it worked).
@vijayarjunwadkar3 жыл бұрын
Simply WOW! While we have many functions available which are good by themselves, putting them together in smart way to solve practical problems this easily, is just another thing! Great! Thanks for sharing, keep EXCELling! 😊👍
@MrJamesHWard2 жыл бұрын
You just solved a big problem for me. I think you're an excellent person for making this video for the world to learn about. Thank you so much.
@rajeevgosavi45142 ай бұрын
Sumitji, Your tutorials are always very informative, innovative, still simple to understand. We really appreciate your skills. Last time also I commented and requested you to also put up a video on how to use power query in a given scenario. Thanks in advance. Or if you have already put up such video, kindly share the reference. Thanks.
@adityasharma01013 жыл бұрын
Dude you are blowing my mind. Usage and Unique and If was impressive enough...and you brought along the textjoin too. At first I thought...why aren't you using Concat formula ..but when I practiced myself..I realized that this text join is a great great enhancement to concat formula...
@trumpexcel3 жыл бұрын
Thanks for commenting Aditya... Glad you found the video useful :
@ahmedaiad3372 Жыл бұрын
a great method in simplifying and explaining how formulas go accurate
@vee9196Ай бұрын
Awesome. Your approach of this using simple formula solved my complex problem which I was struggling to achieve with Vlookup. Thank you very much
@trumpexcelАй бұрын
Glad the video helped 🙂
@vee9196Ай бұрын
I am impressed with this video hence i subscribed to your channel. I will go through your videos during my free time.
@MalikBabarHasan608557 ай бұрын
Extra Ordinary, best ever formula giving us level upto programmer level thanks....
@mohammedalmutairi98062 ай бұрын
This was Truly EXTREAMOLY HELPFUL, TAHNK YOU SO MUCH MAN
@trumpexcel2 ай бұрын
Glad the video helped 🙂
@konather8065 Жыл бұрын
I have searched for hours for this exact solution, Thank you!
@jennydrumm72233 жыл бұрын
OMG! My mind is completely blown! This is genius! (Actually, I was first dumbfounded when you showed the UNIQUE formulas and stayed that way through the whole video. Thank you SO much!)
@KlaraBreznik-jm9pj4 ай бұрын
This video is a life saver. Thank you, thank you, thank you..... this is exactly what i needed.
@trumpexcel4 ай бұрын
So happy to know that the video was helpful 🙂
@Stevie741332 жыл бұрын
Thank you so much I was wasting time trying to do this same exact thing and your video gave me quick and easy fix!
@krnaveengupta Жыл бұрын
Excellent... My search for a solution ended after seeing your video..Great ...keep it up
@romcorleone Жыл бұрын
Thank you very much my friend. Doing the Lord’s work
@harikrishnanselvaraj17322 жыл бұрын
There are many times scratching my head to do this. This is really handy.
@bharatarse15032 жыл бұрын
Wow really amazing. I will going to use it. Keep sharing excel tricks.
@oOomadboyoOO Жыл бұрын
you just saved us soooo much time, thank you from Brazil
@souravchauhan7631 Жыл бұрын
Thank you for this. Had been struck in this problem for a long time. Very helpful.
@wantsoobaroo2 жыл бұрын
Straight to the point. TY. Was getting frustrated with all the other excel videos out there.
@edwardjacobe48342 жыл бұрын
I was looking for this formula. Thank you and God bless.
@yelagiriramcottagevenkatav91002 жыл бұрын
Excellent was searching here and there for this multiple match and landed in your explaination worked so simple ... Thanks a lot keep posting more tips
@shrimaanlalitsingh18702 жыл бұрын
Surely i am going to watch your all videos😁
@piyushakushwaha3 жыл бұрын
awesome!! my issue was exactly similar and it helped me perform better in finishing up the tedious task of 2-3 hours in just one go. love you man!
@swindonbob10 ай бұрын
Fantastic explanation - very clear
@nazarkamal88318 ай бұрын
Thanks a lot this is what exactly i am looking for long days 👍👍👍👍👍👍
@shikharbudhiraja76863 жыл бұрын
Best ever! Doesn't take much computational power as well!
@keilo3382 жыл бұрын
Brilliant code! Nice!! Exactly what I’m looking for!!!
@stephengaldo2690 Жыл бұрын
Thanks for making it simple. God Bless
@thejus2255 Жыл бұрын
thanks brother - I was searching for a solution throughout the internet !!!!!
@juanpablodelgadoguirola37582 жыл бұрын
You help me to keep my dream job thanks :)
@asmrindia3 жыл бұрын
Excellent Sir
@piotrpp5478 Жыл бұрын
Fantastic! Saved my butt! Thank you!
@poojasainkar14582 жыл бұрын
Excellent you are a saviour !!
@vikramraghuwanshi94553 жыл бұрын
Thanks for your valuable information regarding his topic.
@OzduSoleilDATA3 жыл бұрын
AWWWW man! This is so sweet! WOW!
@trumpexcel3 жыл бұрын
Glad you liked the video Oz... How's the Excel hash challenge coming along? I am pulling my hair trying to get a coherent solution ready
@lopher703 жыл бұрын
Very kind of you comment Oz, great exceler, even greater person
@keithau81593 жыл бұрын
Yes.Salute,salute and salute to my dearest ancient lost civilization God===Khilasa Temple,really Wonder of the world,craft from bed rock as hard as granite not sand stone or limestone.Masterpiece,masterpiece and masterpiece=famous 80's pop song and musics.
@sudhakarjain12992 жыл бұрын
So easy you explain, it is quite an easy to learn
@jayeshkiniwildlife2 жыл бұрын
U r a time saviour 👍
@00904242 жыл бұрын
THANK YOU! I've been trying to figure out how to do this on and off for MONTHS without having to use pivot tables or query.
@00904242 жыл бұрын
Just kidding, didn't return all the values I wanted it to
@ravisankarganesan9767 Жыл бұрын
Excellent, Simply Amazing! This is exactly what I am looking for. Thank you very much for this video!!!👍👍👍
@muhammadnazar29783 жыл бұрын
A different way having very Useful Technique! Thanks a lot
@jhadsnju2 жыл бұрын
This is pretty good and you got one more subscriber on your channel. From long time I was searching how to return multiple value in one cell, thanks for sharing👍
@saravanananamalai11142 жыл бұрын
Bless you SUMIT and thank you.
@akshaykadam79923 жыл бұрын
Genius bro... Actually my search for excel is stopped on your channel.... One for multiple problems... Can you please make one video on new formulas on m excel?
@missladyyannick95872 жыл бұрын
Thank you so much for sharing this. Very useful to me.
@FAVisionEnterprise Жыл бұрын
Been searching for this function for ages.
@rishavjoshi4293 Жыл бұрын
Was looking for this quite a while, thank you so much.
@GiSStation Жыл бұрын
That's the thing i want, great brother , thank you
@vivekpalle3403 Жыл бұрын
Excellent!!
@MrDkumar1083 жыл бұрын
Bhai Ji very very useful video. It saved lot of hrs of mine
@trumpexcel3 жыл бұрын
Thanks for commenting Dhananjay... Glad you found the video useful!
@anilrungta46643 жыл бұрын
Superb bro I subscribed you immediately after this. This is how I want videos to be clear, crisp, nothing extra only to the the point discussion.
@pradeepjangid4903 жыл бұрын
Brother Your every video has a great tutorial of excel depth knowledge
@pradeepjangid4903 жыл бұрын
I want to concatenate various cell reference in a single cell by "&" character. Than I want to bold some cell reference only Can this possible without VBA.
@naingtun66202 жыл бұрын
Thank a lot ,I want to know this function for a long time
@Mayurbhoir052 жыл бұрын
Awesome..I was looking for this only
@LeonardoRojasEliassen Жыл бұрын
Thank you so much!!!!! Your the best!
@ollimatik Жыл бұрын
Very useful... love it - thanks!
@imtaxfree2 жыл бұрын
Thank you , it helped me a lot
@josesmagalhaes3 жыл бұрын
Thank you so much for sharing this. This will make my work easier from now on.
@abhishekshah68622 жыл бұрын
You saved the day!
@carlosmartinezreborned64032 жыл бұрын
Great Tip and Tutorial, thank you so much for sharing your knowledge
@DenisMolla3 жыл бұрын
Wow, thank you! Everyone else using complicated formulas... (OK, Unique is a new formula, though, great anyway)
@mia5134 Жыл бұрын
This is a lifesaver, thank you very much.
@Studyinginhu Жыл бұрын
Incredibly good! thank you!
@mfmalth5 ай бұрын
superb thanks
@farmanahmed57473 жыл бұрын
Thanks for such an unique video
@anthonyfisiihoi Жыл бұрын
EXCELlent video! Thanks!
@michaellau6242 жыл бұрын
Hi Man, really appreciate what are you doing You really save my time! keep up
@wholefoodsofficial85303 жыл бұрын
Sumit you are a life saver!!!
@vishal3620 Жыл бұрын
Thanks so.much solved my problem
@dayanandsarwade99733 жыл бұрын
thanks brother, i really wanted to seek this one, in my daily working, it really helps
@tinaotchere2 жыл бұрын
Thank you this helped me soo much!
@educacionportable3 жыл бұрын
Wow nice job! God bless you more
@Ja5pr33t3 жыл бұрын
You are amazing and a life saver. Just saved me 2 hours of work. 😁
@NevilleVakharia1 Жыл бұрын
Super helpful. Thanks!
@Ryan065052 жыл бұрын
Love this - saved me a bunch of time trying to get creative! Thanks again!
@jusjerm2 жыл бұрын
This worked perfectly! Thank you so much for sharing this approach.
@leonrobinson20534 ай бұрын
Exactly what I needed and great explanation
@pankajlamba9feb Жыл бұрын
Excellent Thanks for the Info😃
@letusfindtruth2 жыл бұрын
It was very informative tnanks 💮🌼
@alinedesouza44272 жыл бұрын
Awesome! thanks so much for sharing
@aminadam3362 Жыл бұрын
Great video, thanks. Please note that if any of the values within your referenced range contains #N/A error, the output of this formula also throws up the #N/A error.
@PaperKraftsIN Жыл бұрын
Thanks dude. You literally saved me.
@nasma.e7440 Жыл бұрын
Amazing, thank you so much! 😍
@DessyBlueberryCards3 жыл бұрын
You just helped a whole team! Thanks a lot for sharing this video! :)
@adandaer Жыл бұрын
It helped me to go around if I dont know how to do it directly in SQL which would be direct way.... but if way A i dont know, I used this way B :)
@baditya36912 жыл бұрын
beautifully explained. It is an apt solution i am looking for. thanks a lot.