How To Retain Or Revert Back To Original Sort Order In Excel

Excel Campus - Jon
Excel Campus - Jon
182.6 هزار بار بازدید - 6 سال پیش - Sign up for our Excel
Sign up for our Excel webinar, times added weekly: www.excelcampus.com/blueprint-registration/ In this video I explain how to retain the original sort order of a range or table so you can revert back to it after sorting other columns. This is handy when the data does not have a column of sequential values and you want to make sure you can restore the original order of the data after sorting or modifying it. In the video I present one solution using an index column. However, there are probably other ways to go about this. Please leave a comment below with any suggestions you have for solving this problem. Thank you! 🙂 Additional Resources: Beginner's Guide to Excel Tables:    • Excel Tables Tutorial: Beginners Guid...   How to Quickly Delete Rows by Sorting First: www.excelcampus.com/tips/sort-data-before-deleting… 4 Ways to Sort Drop-down Lists Automatically:    • 4 Ways to Sort Drop Down Lists Automa...  
6 سال پیش در تاریخ 1397/12/24 منتشر شده است.
182,601 بـار بازدید شده
... بیشتر