🔠 Sort Names by Last Name in Excel — No Helper Column Needed! Ever wanted to sort a list of full names by last name instead of first name? Here’s a one-line Excel formula that does it magically 👇 =SORTBY(A3:A12, TEXTAFTER(A3:A12, " "), 1) 💡 How it works: TEXTAFTER(A3:A12, " ") extracts the text after the first space — that’s the last name. SORTBY() then sorts the original list based on those extracted last names. ✅ No manual splitting ✅ Works dynamically ✅ Perfect for name lists, directories,
🔠 Sort Names by Last Name in Excel — No Helper Column Needed! Eve…
2.5K views3 weeks ago
FacebookExcel By Vikal
How to Create a Drop Down List in Excel (the Only Guide You Need)
9:31
How to Create a Drop Down List in Excel (the Only Guide You Need)
Nov 26, 2015
trumpexcel.com
List of Worksheets in a Drop Down - Excel University
16:59
List of Worksheets in a Drop Down - Excel University
May 27, 2020
excel-university.com
How to make dependent dropdown lists in Excel
How to make dependent dropdown lists in Excel
Nov 22, 2022
exceljet.net
Named Ranges in Excel
Named Ranges in Excel
Oct 24, 2023
exceljet.net
How to Split or Reverse First Last Names in Excel
How to Split or Reverse First Last Names in Excel
4 months ago
contextures.com
Excel Tips: Select an Entire Row or Column
Excel Tips: Select an Entire Row or Column
Aug 2, 2018
gcfglobal.org
3:15
How to make a dependent (cascading) drop-down list in Excel
Apr 5, 2023
ablebits.com
5:14
Excel Split Names Tutorial
574.3K viewsOct 16, 2017
YouTubeTechnology for Teachers and Students
8:37
Excel Drop Down List Tutorial
1.2M viewsJan 2, 2020
YouTubeKevin Stratvert
14:22
Create Searchable Dropdown List In Excel
137.5K viewsApr 30, 2014
YouTubeMy E-Lesson
1:43
Using named cells in Excel
167 viewsSep 11, 2019
YouTubeIV, STAT!
1:06
Select cells in Excel
211.8K viewsOct 16, 2019
YouTubeMicrosoft 365
4:25
How to Separate Names in Excel
208.7K viewsJan 14, 2020
YouTubeKevin Stratvert
9:11
Microsoft Lists - create a list from Excel
40.4K viewsJun 13, 2020
YouTubeMark Kashman
11:10
Dependent Drop Down List in Excel Tutorial
685.5K viewsJul 6, 2021
YouTubeKevin Stratvert
1:32
How to add a drop-down list in Microsoft Excel
583.6K viewsApr 26, 2021
YouTubeMicrosoft 365
3:37
How To Create Drop Down List and Display Different Values In Excel
87.2K viewsDec 2, 2020
YouTubeExcel 10 tutorial
1:03
How to Randomize a List In Excel
279.6K viewsJan 29, 2019
YouTubelearnexcel.video
13:43
Searchable Drop-Down List in Excel - The Easy Way
110.3K viewsJan 28, 2020
YouTubeComputergaga
8:09
How to Create A Multi-Select Drop-Down List in Excel
235.2K viewsNov 3, 2020
YouTubeSharon Smith
18:37
🔎 How to Create Searchable Drop Down List in Excel
407.4K viewsJul 19, 2021
YouTubeKevin Stratvert
7:38
List Slicer Selections in a Cell in Excel
50K viewsMay 11, 2021
YouTubeTeachExcel
7:04
How to Select Multiple Items From an Excel Drop Down List
474.3K viewsFeb 21, 2017
YouTubeTrumpExcel
1:01
How to create a drop-down list in Microsoft Excel
1.3M viewsJan 20, 2021
YouTubeMicrosoft 365
2:40
Choose A Random Name From A List In Excel – Using RANDBETW…
2.6K viewsJan 11, 2021
YouTubeThe Excel Hub
6:01
How to Sort and Filter Your Data in Excel
54.5K viewsMar 30, 2021
YouTubeSimply Excel
2:19
MS Excel: How to Select All Specific Value, Data & Cell (Easy)
68.5K viewsFeb 9, 2018
YouTubeMJ Tube
4:18
How to Name Cells and Ranges in Excel (Stop Using Confusing Cell …
13.5K viewsAug 25, 2020
YouTubeMatt Macarty
3:06
How to Create Drop down Lists in Excel Using Named Ranges
16.1K viewsJul 6, 2021
YouTubeExcel 10 tutorial
See more videos
Static thumbnail place holder