Download Excel File: https://excelisfun.net/files/EMT1821.xlsx
Learn about how to sort a column of full names (including middle names) by last name using an Excel Formula. See 4 different methods, including Microsoft 365 Excel methods and methods that will work in older versions of Excel.
Topics:
1. (00:00) Introduction
2. (00:21)
3. (00:37) Microsoft 365 Excel Formula (Easy One), SORTBY, TEXTAFTER, LEN and SUBSTITUTE functions.
4. (01:57) Crazy M 365 Excel Formula #1. LOOKUP, BYROWS, LAMBDA, TEXTSPLIT, SORTBY functions with BIG Text Lookup Value “zzzzzz”.
5. (03:57) Crazy M 365 Excel Formula #2. Same as #2, but using BIG Text Lookup Value “Ω”.
6. (04:31) Old School Method that can be used in any version of Excel. SUBSTITUTE, REPT, LEN, TRIM, COUNTIFS, INDEX, ROWS, MATCH functions.
7. () Summary
8. (00:47) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #microsoftexcel #microsoftmvp #countifs #indexfunction #index #sort #sortby #lookup #last #lambdaexpression