'Trick' to restore original sort order after data modified?
 

Had large excel file. Sorted to combine like type part #. Updated pricing,
would like to restore back to original list order? Normally insert a new
column and sequentially number. Use this filled sequential field to go back
to original order. Any tool in new excel that replaces the need to do this?

Answer: 'Trick' to restore original sort order after data modified?
 

Yes, there is a simple trick in Excel that can help you restore the original sort order after modifying data. Here are the steps:

1. Before you sort your data, add a new column to your worksheet. Let's call it "Sort Order".
2. In the first cell of the Sort Order column, enter the number 1.
3. In the cell below it, enter the formula "
   Code:

   ---

   =A2=A1+1

   ---

   ". This will check if the value in cell A2 is one more than the value in cell A1. If it is, it will return TRUE, otherwise it will return FALSE.
4. Copy the formula down to the end of your data.
5. Sort your data as desired.
6. Once you have finished updating your pricing, select the entire Sort Order column.
7. Sort the Sort Order column in ascending order.
8. Your data will now be restored to its original order.

This trick works by using the sequential numbering in the Sort Order column to restore the original order of your data. By sorting the Sort Order column in ascending order, you are essentially sorting your data by the order in which it was originally entered.

'Trick' to restore original sort order after data modified?
 

Nope... Keep adding in your sequence number.
--
HTH...

Jim Thomlinson


"L Welker" wrote:

Had large excel file. Sorted to combine like type part #. Updated pricing,
would like to restore back to original list order? Normally insert a new
column and sequentially number. Use this filled sequential field to go back
to original order. Any tool in new excel that replaces the need to do this?

'Trick' to restore original sort order after data modified?
 

Yes, reload the file without saving ;-)

L Welker wrote:

Had large excel file. Sorted to combine like type part #. Updated pricing,
would like to restore back to original list order? Normally insert a new
column and sequentially number. Use this filled sequential field to go back
to original order. Any tool in new excel that replaces the need to do this?

'Trick' to restore original sort order after data modified?
 

If your original data had been sorted, and you knew the conditions of the
sort, you could just repeat them.........but personally, I always do what you
do as soon as I get a new database to fool with.....just add a column and
sequentially number it so I can return to the original sort at any
time.........a macro might help if you do it a lot.

Vaya con Dios,
Chuck, CABGx3



"L Welker" wrote:

Had large excel file. Sorted to combine like type part #. Updated pricing,
would like to restore back to original list order? Normally insert a new
column and sequentially number. Use this filled sequential field to go back
to original order. Any tool in new excel that replaces the need to do this?