🔠 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.7K views1 month ago
FacebookExcel By Vikal
How to Sort by the Last Name in Excel (Easy Guide)
11:52
How to Sort by the Last Name in Excel (Easy Guide)
Jan 11, 2020
trumpexcel.com
List sheet names with formula
List sheet names with formula
Mar 20, 2024
exceljet.net
4 Ways to Create Numbered Lists in Excel - Excel Campus
4 Ways to Create Numbered Lists in Excel - Excel Campus
Apr 12, 2022
excelcampus.com
Named Ranges in Excel
Named Ranges in Excel
Oct 24, 2023
exceljet.net
Rank and score with INDEX and MATCH
Rank and score with INDEX and MATCH
Nov 1, 2023
exceljet.net
Sort data in a range or table in Excel
1:09
Sort data in a range or table in Excel
Oct 28, 2014
Microsoft
5:31
HOW TO ARRANGE STUDENT RECORD ACCORING TO NAMES …
258.7K viewsMar 29, 2019
YouTubeThink Technically Era
5:37
XLOOKUP & Named Ranges: use them together for workbooks with …
4.6K viewsAug 20, 2022
YouTubeBitesize Excel
How to Create a Dynamic Names List Based on Status in Excel
8 months ago
YouTube
1:27
Sort Excel Worksheets in alphabetical order in 90 seconds
34.9K viewsJan 22, 2018
YouTubeKwikTrix
2:50
Using Named Ranges in Excel
18.1K viewsApr 21, 2017
YouTubeIQ Accounting Solutions
7:14
Categorising Excel Data using VLOOKUP
86.4K viewsOct 14, 2010
YouTubeOut of the Hat Ltd
3:19
How to Create Custom Lists in Excel
116.3K viewsJul 24, 2018
YouTubeMDTechVideos
2:30
How to Create Named Range in Excel - Office 365
136.8K viewsSep 10, 2020
YouTubeFind Easy Solution
3:38
How to Sort Alphabetically in Excel
655.1K viewsSep 24, 2019
YouTubeExcel Tutorials by EasyClick Academy
13:29
Excel Sorting and Filtering Data
1M viewsJun 7, 2018
YouTubeThe Organic Chemistry Tutor
5:22
What is Named Range & How to Use it in Excel
13K viewsJul 5, 2021
YouTubeExcel 10 tutorial
12:06
How to Create a Summary Report from an Excel Table
1.6M viewsSep 19, 2011
YouTubeDanny Rocks
2:22
Excel Quick Tip: What are Named Ranges?
93.3K viewsJul 2, 2018
YouTubeLearnFree
1:05
How to Sort Excel by Alphabetical Order
4.3K viewsMay 29, 2018
YouTubeHOWZA
1:03
How to Randomize a List In Excel
280.1K viewsJan 29, 2019
YouTubelearnexcel.video
4:38
Basic Scoring Method Using Excel
81.4K viewsSep 30, 2016
YouTubeYour Friendly Economist
9:17
Randomly Assign Names to Groups - Excel Formula
164.9K viewsAug 21, 2018
YouTubeComputergaga
5:36
How to Do Multi level sorting in Excel (by two Columns)
212.9K viewsMay 16, 2018
YouTubeTrumpExcel
13:08
How to Create Named Ranges to Use in Excel Formulas
332.3K viewsFeb 9, 2012
YouTubeDanny Rocks
18:48
How to Make an Excel Order Form
98.5K viewsFeb 5, 2019
YouTubeContextures Inc.
3:06
How to Create Drop down Lists in Excel Using Named Ranges
16.2K viewsJul 6, 2021
YouTubeExcel 10 tutorial
5:12
How to grade, rank and give Remarks in Excel
145K viewsNov 6, 2017
YouTubeTutor Francis
6:15
Pick a Name or Names at Random from an Excel List
16.2K viewsJan 7, 2021
YouTubeChester Tugwell
See more videos
Static thumbnail place holder