excelisfun | Excel Formula to make First a 1, Second a 2, Third a 3, and so on. 6 Formula Examples. EMT 1797 @excelisfun | Uploaded 2 years ago | Updated 1 day ago
Download Excel File: https://excelisfun.net/files/EMT1795-1797.xlsx
Buy excelisfun new book at Mr Excel Web Site: https://excel.bookstore.ipgbook.com/microsoft-365-excel--the-only-app-that-matters-products-9781615470709.php
Buy excelisfun new book at Amazon: https://www.amazon.com/Microsoft-365-Excel-Calculations-Analytics/dp/1615470700
Learn how to convert words such as First, Second and Thirds, to numbers such as 1, 2 and 3..
Topics:
1. (00:00) Introduction
2. (00:20) XLOOKUP solution
3. (01:09) XMATCH solution
4. (01:48) XMATCH Spilled Array Formula solution
5. (02:31) VLOOKUP Old School solution
6. (02:59) MATCH Old School solution
7. (03:31) Summary
8. (03:41) Closing, Video Links