🔠 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,
FacebookExcel Tricks.
🔠 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
Excel Tricks.. Excel Tricks. · Original audio. 🔠 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 ...
406 views1 month ago
Excel Sorting Numbers
Effortless Date Autofill In Excel: Make Your Workflow Simpler!
1:00
Effortless Date Autofill In Excel: Make Your Workflow Simpler!
YouTubeExcel Campus - Jon
595.3K viewsMay 17, 2023
New Excel Feature: Insert Picture In Cell
0:54
New Excel Feature: Insert Picture In Cell
YouTubeExcel Campus - Jon
286.1K viewsJun 6, 2023
Dynamic Drop-down List in Excel using Spill Range & FILTER Function | Smart Data Filtering Tutorial
1:52
Dynamic Drop-down List in Excel using Spill Range & FILTER Function | Smart Data Filtering Tutorial
YouTubeIICA Computer Education
37.8K views1 month ago
Top videos
How to SORT in Excel (by Rows, Columns, Colors, Dates, & Numbers)
5:36
How to SORT in Excel (by Rows, Columns, Colors, Dates, & Numbers)
trumpexcel.com
May 16, 2018
List sheet names with formula
List sheet names with formula
exceljet.net
Mar 20, 2024
Create a List of Names by comparing two lists which are not included in both lists in Microsoft Excel | Excel Basement
0:27
Create a List of Names by comparing two lists which are not included in both lists in Microsoft Excel | Excel Basement
FacebookExcel Basement
993.5K viewsNov 10, 2022
Excel Number Formatting
Highlight Active Row and Column in Microsoft Excel
1:10
Highlight Active Row and Column in Microsoft Excel
TikTokfunctional.excel
386.7K views1 month ago
Efficiently Open Series Tool in Excel: Tips & Tricks
0:19
Efficiently Open Series Tool in Excel: Tips & Tricks
TikTokcheatsheets
7.1M viewsApr 4, 2023
5 Excel Shortcuts for Data Formatting | Boost Your Speed in Minutes!
0:57
5 Excel Shortcuts for Data Formatting | Boost Your Speed in Minutes!
YouTubeIICA Computer Education
58.5K views1 month ago
How to SORT in Excel (by Rows, Columns, Colors, Dates, & Numbers)
5:36
How to SORT in Excel (by Rows, Columns, Colors, Dates, & Numbe…
May 16, 2018
trumpexcel.com
List sheet names with formula
List sheet names with formula
Mar 20, 2024
exceljet.net
Create a List of Names by comparing two lists which are not included in both lists in Microsoft Excel | Excel Basement
0:27
Create a List of Names by comparing two lists which are not …
993.5K viewsNov 10, 2022
FacebookExcel Basement
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
Sort numbers ascending or descending
Sort numbers ascending or descending
May 17, 2024
exceljet.net
How to use named ranges with tables
How to use named ranges with tables
Oct 27, 2022
exceljet.net
How to Create a Checklist in Microsoft Excel
How to Create a Checklist in Microsoft Excel
Dec 7, 2020
howtogeek.com
How to Sort Data in Excel Spreadsheets (The Right Way) | E…
Jun 7, 2017
tutsplus.com
How to Sort Mixed Numbers and Text Using String Functions - Exc…
Sep 4, 2013
exceltactics.com
2:24
Minecraft cave sounds as actually disturbing monsters
17.9K views3 months ago
YouTubeLimonade
3:52
How to Combine First and Last Names in Excel
48 views3 weeks ago
YouTubeArtic Stream
3:41
The Fastest Way To Create Defined Names In Excel.mp4
54.4K viewsMay 28, 2012
YouTubeK2 Enterprises
2:54
Excel Data Sorting Tips & Tricks | Master Sorting Like a Pro!
276 views9 months ago
YouTubeShahab Islam
4:42
How to Draw a Winner From a List of Names in Excel | RandBetween an…
741 viewsDec 4, 2023
YouTubeJopa Excel
Document of Special Optimal Marks Dated 24.03.2024
275.3K viewsFeb 1, 2023
TikTokfrekkkk8
5:31
HOW TO ARRANGE STUDENT RECORD ACCORING TO NAMES …
258.7K viewsMar 29, 2019
YouTubeThink Technically Era
12:27
SECRET Excel Named Range Shortcuts to Save Time
54.7K viewsApr 28, 2022
YouTubeMyOnlineTrainingHub
Excel List the most frequent occurrence name or number from …
573 views9 months ago
YouTubeExcel Bootcamp
0:49
Count occurrences of items in a list in Excel - Excel Tips and Tricks
2.1K viewsAug 4, 2024
YouTubeJasmine Jones
5:37
XLOOKUP & Named Ranges: use them together for workbooks with …
4.6K viewsAug 20, 2022
YouTubeBitesize Excel
5:07
How to rank numbers in Excel in descending order (highest to lowe…
320 viewsJun 14, 2023
YouTubeMinh Nguyen
10:32
Excel Basics #6: Names Cell Ranges and Functions
119.7K viewsDec 16, 2008
YouTubeexcelisfun
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.8K 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.7K viewsOct 14, 2010
YouTubeOut of the Hat Ltd
3:19
How to Create Custom Lists in Excel
116.3K viewsJul 24, 2018
YouTubeMDTechVideos
6:50
Calculating Z Scores using Excel
19K viewsFeb 4, 2015
YouTubeDr. Todd Grande
2:30
How to Create Named Range in Excel - Office 365
136.9K viewsSep 10, 2020
YouTubeFind Easy Solution
See more videos
Static thumbnail place holder