Sort Function

[muhammadbilal6]

Is there method to undo sort...........because if you apply sort function all cells are shifted according to sort function applied, but how can we undo this sort as the arrangement of cells remain the same after sort function.

 

[Muhammad_Usman]

Is there method to undo sort...........because if you apply sort function all cells are shifted according to sort function applied, but how can we undo this sort as the arrangement of cells remain the same after sort function.

You can do this with helper column , Add a column with "serial no" , after sort and your calculation you can sort "serial no" wise back to first situation.