How to Sort by Last Name in Excel (3 Easy Ways)

[@SimonDMal]

The guy seems to be a genius. Imagine thinking through the potential problem in this particular scenario and apply an easy teaching method to show us the solution.

[@ruthhanson3606]

Thank you!! This was exactly what I needed. Your instruction is very clear. Thank you!

[@icepuck14]

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!

[@trumpexcel]

Thanks Cory.. Glad you found the video useful :)

[@Sekhar_Home]

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

[@trumpexcel]

Thank you so much for the kind words.. I am glad you found the video useful!

[@brucetew]

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!

[@darkoldrocknroller]

The formula is brilliant! Great job in showing the steps.

[@trumpexcel]

Glad you found the video useful Jim :)

[@DrunkenKnight71]

That last formula trick is just what I need, thanks!

[@puneetvij8433]

Sumit Sir, मैं आपके चैनल का regular viewer हूं, आपके excel tips and tricks एकदम real time job problem-solving होते है | Keep it up and Keep going! ; )

[@trumpexcel]

Glad you're finding the videos useful Puneet!

[@sbeku]

Mr. Sumit From Saudi Arabia my hat's off to you

[@Nadira_197]

amazing video! very helpful.

[@QuetzTelyVizion]

Thank you so much! Really appreciate your clear explanation step by step. This is great! 🙌🏽

[@syedfamuneeb8654]

Just excellent!! I don't have anything else to say.

[@sree9355]

🙂🙂🙂🙂 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.

[@lidsnz8296]

Thank you so much! Your video helped me to complete the study assignment :)

[@robertlewisvideo]

Brilliant Teaching Method. Just found your site and Subscribed.

[@trumpexcel]

Good to have you Robert...Glad you liked the videos :)

[@bycottfrenchproducts.mukht1189]

Nice to see u second time on video..keep coming like this bro..and u r doing great job wish u great success.

[@trumpexcel]

Thanks Ahmed.. Will create more such videos :)

[@andrearruda9005]

Very useful tips. Thank you!

[@trumpexcel]

Thanks for commenting Andre.. Glad you found the video useful :)

[@sdesigns-bringingyourvisio2305]

Great Tutorial

[@MySivaraja]

Mostly i dont like edu video in excel from Indians but I see only one indian video that is you Amit... Thank u

[@boonedockjourneyman7979]

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.

[@cutechickiewaffles7476]

THANK YOU!

[@LuiCardenasphotography]

Thank you so much!

[@Federals123]

Great job - thanks!

[@cherylward5315]

Thank you sir. 🙌🏽⚘🙏🏽

[@alyyoussef1722]

Thank u Perfect !!!!

[@alexrosen8762]

This was really useful!

[@alexandermcquarrie2732]

Brilliant

[@bridget23611]

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!

[@abdelrahmanmohamed6701]

greeting from egypt

[@FarhanKhan-ze3oe]

Genius

[@wayneedmondson1065]

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!

[@trumpexcel]

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.

[@brucetew]

Thanks for mentioning the Flash Fill. I was not experienced with that next process. Thank You for Sharing.

[@wayneedmondson1065]

@@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!

[@manndipp]

Just wow

[@robo7981]

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

[@jackkevadiya5359]

Bhai 2 5 kg ka Thanks apko Obama Salute to Trump Excel

[@HakanAnil]

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);" ";"")))))

[@brucetew]

That solves the problems that I was experiencing. Thank you for Sharing!

[@brucetew]

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!

[@ExcelBytes]

Great video. Wouldn't a possible fourth method be Flash Fill?

[@rhmanagoli]

Dear Sir, Best video for learning, Can you make some videos on Excel VBA ?

[@trumpexcel]

You can access all the VBA videos here - kzbin.info/aero/PLm8I8moAHiH2n5HC4ZXBgS-cBLjxWDreu

[@rhmanagoli]

@@trumpexcel Thank you Sir

[@debrahealy6086]

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.

[@vishalchauhan2907]

Sir is there any formula where number is same but name are different i want a common name please sir help

[@shanedorn5188]

Use flash fill… takes 10 seconds and is in your drop down menus already.

[@AnkitVerma-cn3px]

Fucking awesome.

[@nitinjohri8294]

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 KZbin 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

[@redhaakhund1271]

⭐️⭐️⭐️⭐️⭐️🌹