Hi,

Copy the data and do the sorting as I suggested in my previous response.

Or, create a helper column say (E2:E101) containing running numbers (1, 2,
3, ...)
Select the entire data including Column E, and sort as I suggested earlier.
To restore the data back to the original arrangement, select the entire data
and sort by Column E ascending.

Regards,
B. R. Ramachandran

"kraljb" wrote:


Sorting works, but I am not supposed to edit the original data. It is
used in that format for other purposes.


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=484432