Excel Help Needed....

3 posts · originally from https://geek.digit.in/community/threads/excel-help-needed.107868/

Hi Friends,

Consider a set of 1000 records, My work need that data to be sorted out. After finishing my work, i need that data back to the same position before sorting. ( Data was not in Any correct order in original ) But my work should persists ( No Ctrl + Z ). I Tried with Filters, i cant able to achieve.

Kindly help to achieve this process in Excel.

Thanks and Regards
Your Vijay

How about this:

1. Add another column at the end. Fill it up with sequence numbers (Fill the first row with 1 and use the small right bottom corner to drag and auto-fill the remaining 1000+ rows)
2. Sort using your desired column and get your work done.
3. To resume the worksheet to its original sort order, sort using the column added in #1 above. This way, you have your original sort order back.
4. If required, delete the additional column added in #1

Excellent Trick Boss... Thanks a lot.. i 'll try