🔠 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 By Vikal
🔠 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 By Vikal. Excel By Vikal · 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 ...
已浏览 2661 次1 个月前
Excel Sorting Tricks
Excel: Sorting Data
4:31
Excel: Sorting Data
YouTubeLearnFree
已浏览 109.7万 次2016年2月8日
Ultimate Guide to FILTER, SORT, and SORTBY Functions in Excel: Beginner Tutorial
43:31
Ultimate Guide to FILTER, SORT, and SORTBY Functions in Excel: Beginner Tutorial
YouTubeSimon Sez IT
已浏览 3001 次5 个月之前
Sorting in Excel
7:09
Sorting in Excel
YouTubeTechnology for Teachers and
已浏览 10.6万 次2018年8月13日
热门视频
Custom Sort List with Formula - Excel & Google Sheets
Custom Sort List with Formula - Excel & Google Sheets
automateexcel.com
2023年2月8日
How to Create Custom List in Excel (Easy Step-by-Step Guide)
2:19
How to Create Custom List in Excel (Easy Step-by-Step Guide)
trumpexcel.com
2019年10月23日
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
2018年5月16日
Excel Filter and Sort
Excel Sorting and Filtering Data
13:29
Excel Sorting and Filtering Data
YouTubeThe Organic Chemistry Tutor
已浏览 103.5万 次2018年6月7日
How to Sort and Filter Your Data in Excel
6:01
How to Sort and Filter Your Data in Excel
YouTubeSimply Excel
已浏览 5.5万 次2021年3月30日
Excel: How to Filter & Sort Data & Columns in Microsoft Excel - Sort A to Z Filter Settings Tutorial
3:51
Excel: How to Filter & Sort Data & Columns in Microsoft Excel - Sort A to Z Filter Settings Tutorial
YouTubeBein' Classy
已浏览 1.2万 次2022年10月8日
Custom Sort List with Formula - Excel & Google Sheets
Custom Sort List with Formula - Excel & Google Sheets
2023年2月8日
automateexcel.com
How to Create Custom List in Excel (Easy Step-by-Step Guide)
2:19
How to Create Custom List in Excel (Easy Step-by-Step Guide)
2019年10月23日
trumpexcel.com
How to SORT in Excel (by Rows, Columns, Colors, Dates, & Numbers)
5:36
How to SORT in Excel (by Rows, Columns, Colors, Dates, & Numbe…
2018年5月16日
trumpexcel.com
How to Sort by the Last Name in Excel (Easy Guide)
11:52
How to Sort by the Last Name in Excel (Easy Guide)
2020年1月11日
trumpexcel.com
Create List of Hyperlinked Sheet Names in Excel - Goodly
Create List of Hyperlinked Sheet Names in Excel - Goodly
2019年3月1日
goodly.co.in
Learn how to use Custom Sorting in Excel to organize your data just the way you need. Whether you want to sort names, months, or categories in a specific order, this step-by-step guide will show you how to do it easily. Perfect for reports, dashboards, and data analysis. #ExcelTips #ExcelSorting #CustomSort #ExcelTutorial #DataSorting #ExcelTricks #ExcelTraining #MicrosoftExcel #ExcelDashboard #KaushalAccounting #TheCoreSkills | KASH
Learn how to use Custom Sorting in Excel to organize your data just th…
已浏览 1166 次2 个月之前
FacebookKASH
How to Sort in Excel
How to Sort in Excel
2020年12月3日
goskills.com
How to Sort Data in Excel Spreadsheets (The Right Way) | E…
2017年6月7日
tutsplus.com
1:09
Sort data in a range or table in Excel
2014年10月28日
Microsoft
How to Rename a Data Series in Microsoft Excel
2020年7月27日
howtogeek.com
0:33
How to Sort Names by Surname in Excel #shorts #education
已浏览 14 次2 周前
YouTubePeak Productivity Pro
0:35
Sort Names by Last Name in Excel — No Helper Column Needed!
已浏览 2533 次1 个月前
YouTubeXLGenAI
2:52
How Can You Sort Excel Data With Custom Lists? - Docs and Sheets …
2 个月之前
YouTubeDocs and Sheets Pro
3:04
Can Excel Sort Data Using A Custom List Or Specific Departme…
已浏览 1 次2 个月之前
YouTubeDocs and Sheets Pro
7:10
Custom Sort in MS Excel | How to use Custom Sort in MS Excel? | C…
已浏览 1940 次4 周前
YouTubeComputer Tech Academy
1:46
Stop Manually Organizing Names in Excel! Learn at VedantSri #excel #…
已浏览 250 次3 周前
YouTubeVedantSri
2:43
How to Sort Data Using a Custom List in Excel (Step-by-Step Tutorial)
已浏览 29 次2 个月之前
YouTubeTheMercyOlaoluwa
37:16
Sorting, Multi-Level Sorting, and Custom Sorting in Excel – Comple…
已浏览 115 次1 个月前
YouTubeIT TECH
3:58
Excel data sorting, Excel sort function, how to sort data in Excel…
已浏览 6 次1 个月前
YouTubeExcel & Tally with Dipankar
2:45
How Do You Create Custom Sort Lists In Excel? - Docs and Sheets …
已浏览 4 次2 个月之前
YouTubeDocs and Sheets Pro
3:00
How Can You Custom Sort Data In Excel? - Docs and Sheets Pro
1 个月前
YouTubeDocs and Sheets Pro
2:55
What Are Excel Custom Sort Lists Used For? - Docs and Sheets Pro
已浏览 7 次2 个月之前
YouTubeDocs and Sheets Pro
3:20
How Do You Sort Excel Data Using A Custom List? - Docs and Sheet…
1 个月前
YouTubeDocs and Sheets Pro
1:40
Sorting Data in Excel: How to Achieve Custom Sequences with …
已浏览 1 次2 个月之前
YouTubevlogize
1:55
How to Create Custom List in Excel
已浏览 880 次2021年11月11日
YouTubeProgrammingKnowledge2
7:41
Microsoft Excel - Creating Custom Lists to Sort Data in a Specific Order
已浏览 5522 次2022年2月10日
YouTubeOfficeNewb.com
3:27
How to create custom lists in excel and how to use them doing custo…
已浏览 1.2万 次2024年8月21日
TikTokbirungigodfrey
1:27
Sort Excel Worksheets in alphabetical order in 90 seconds
已浏览 3.5万 次2018年1月22日
YouTubeKwikTrix
5:17
Excel Advanced Sorting Options
已浏览 2.3万 次2013年12月18日
YouTubeIQ Accounting Solutions
观看更多视频
静态缩略图占位符