How to Sort by Last Name in Excel (3 Easy Ways)
HTML-код
- Опубликовано: 23 июл 2024
- In this video, I will show you three easy ways to sort the names data based on the last name.
The following three methods are covered in this video:
1. Using the Find and Replace technique
2. Using Text to Columns
3. Using Text Formulas
You can also read more about this here: trumpexcel.com/sort-by-last-n...
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: ruclips.net/user/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Thank you!! This was exactly what I needed. Your instruction is very clear. Thank you!
Really like how you show the formula results, step-by-step. Makes it a hell of a lot easier to actually learn and remember. Keep it up!
Thanks Cory.. Glad you found the video useful :)
This addresses many of the unexpected variants in a first Name, middle initial, commas or periods and Last Name that will help sort by last name correctly. Very simple yet powerful presentation on your video. Thank You!
In one example i learned len, substitute, right, left, find .. i already know last name extraction. But after seeing formula find, i become fan of your teaching
Thank you so much for the kind words.. I am glad you found the video useful!
The formula is brilliant! Great job in showing the steps.
Glad you found the video useful Jim :)
Sumit Sir,
मैं आपके चैनल का regular viewer हूं, आपके excel tips and tricks एकदम real time job problem-solving होते है |
Keep it up and Keep going! ; )
Glad you're finding the videos useful Puneet!
Thank you so much! Really appreciate your clear explanation step by step. This is great! 🙌🏽
amazing video! very helpful.
Thank you so much!
Mr. Sumit From Saudi Arabia my hat's off to you
This was really useful!
Thank you so much! Your video helped me to complete the study assignment :)
That last formula trick is just what I need, thanks!
Outstanding. Most people take on easy problems. This is a hard problem. Imagine a column filled with electronic component numbers. Think about sorting based on just one subunit of those names. Nobody does video on meaningful problems like that.
Great job - thanks!
Nice to see u second time on video..keep coming like this bro..and u r doing great job wish u great success.
Thanks Ahmed.. Will create more such videos :)
🙂🙂🙂🙂
I really liked your third method to get results by Formula upto Nth term.....
Sir, I liked your way of teaching . Getting Formulas with another formula and so on.....
I was knowing only len and right formula.
Now learnt impossible task is now possible with your formulas.
Sir, u r the real master in excel.
THANK YOU!
Brilliant Teaching Method. Just found your site and Subscribed.
Good to have you Robert...Glad you liked the videos :)
Just excellent!! I don't have anything else to say.
Mostly i dont like edu video in excel from Indians but I see only one indian video that is you Amit... Thank u
Very useful tips. Thank you!
Thanks for commenting Andre.. Glad you found the video useful :)
Great Tutorial
Thank u
Perfect !!!!
Thank you sir. 🙌🏽⚘🙏🏽
Really cool! Can you post the last formula so I can copy & paste it? Apparently, I have to do this everyday for my 5 Classes in ZOOM.Any suggestions as to how I would automate the process. Thanks & great video! Rob
Genius
Great video. Wouldn't a possible fourth method be Flash Fill?
Brilliant
OMG, fantastic. Thank you! The ONLY thing that you did not address yet is 'if' the names have a III or initials like MD or PhD. Can you address that? Please alert me so that I won't miss it, if you are able to do this. Thank you again!
Just wow
Bhai 2 5 kg ka Thanks apko
Obama Salute to Trump Excel
greeting from egypt
Hi Sumit.. great video. A quick solution that comes to mind for me is to use Flash Fill to extract the last names. That said, your formula solution is brilliant and for the robust and dynamic nature of it, I would use it every time, unless working with a very simplistic list. Really appreciate you sharing these tips and techniques. You make all of us more productive with each new video. Thank you sir and Thumbs up!
Thanks for commenting Wayne.. I wrote a tutorial about the same topic and included Flash Fill as one of the solutions. trumpexcel.com/sort-by-last-name-excel/
But I have not added it in the video as it was not able to identify the pattern in some cases. And in some cases, it identified the wrong pattern.
Thanks for mentioning the Flash Fill. I was not experienced with that next process. Thank You for Sharing.
@@trumpexcel Hi Sumit. thanks and agreed. Sometimes Flash Fill works great.. other times.. not as well. Your formula solution is the best. Thanks for sharing it. Thumbs up!
Dear Sir, Best video for learning, Can you make some videos on Excel VBA ?
You can access all the VBA videos here - ruclips.net/p/PLm8I8moAHiH2n5HC4ZXBgS-cBLjxWDreu
@@trumpexcel Thank you Sir
Fucking awesome.
Sir is there any formula where number is same but name are different i want a common name please sir help
sar please Excel ke all videos banaaiye ji jaise ki jisme Excel VBA Ho power query Ho Excel dashboard Ho in SAB ke sar please aur videos banaaiyeaur please sir videos RUclips per upload kar dijiye mujhe Excel ki bahut jarurat hai sar please aur video the post kar dijiye. sar please Excel ka 1 complete course ka video banaaiye char se panch ghante ka jismein her topic covered ho
This is the message that I get when I hit "replace all": No cell in the selection contains what you typed, or no records match the criteria.
⭐️⭐️⭐️⭐️⭐️🌹
also try this formula incase there is space (may be by mistake) at he end =RIGHT(TRIM(A2);LEN(TRIM(A2))-FIND("@";SUBSTITUTE(TRIM(A2);" ";"@";LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2);" ";"")))))
That solves the problems that I was experiencing. Thank you for Sharing!
Thank you for sharing the Trim() function that you employed on thes example. I had to change the semi-colon to Comma for my country. Works beautifully. Thank you for taking the time to share!
Use flash fill… takes 10 seconds and is in your drop down menus already.