• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to get the first order back?

N

Ngoc Diep

New Member
I have a file needed to be consolidated, but I couldnt finish it because 2 allocated parts which I shared with my colleagues didnt have the same order. For example, at row 23 the information should be ABC but in the other one this information was located at row 500 and everything mess up.
So I wonder two things:
1/ why the order being changed, my colleague didnt Sort this file.
2/ would it be possible to take the first order back?
Last but not least, how to consolidate if two part were different in the order? Does anyone have any idea, please share with me. I really appreciate your help. Thank you.
 
If you have saved the file you can't undo the last sort

One technique to achieve this is to add an extra Column which contains the record number pre-sort
ie: =Row()
then copy/paste as values

Once sorted you can use this extra column to unsort
 
You must log in or register to reply here.
Back
Top