How To Retain Or Revert Back To Original Sort Order In Excel
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
بـار بازدید شده