Data Sorting
 

Is there any formula for data sorting? Because sorting a range of data change
the sequence of the original data . If there is a formula for sorting the
result of sorting could be seen on different range of cells without
disturbing the original data.

Data Sorting
 

Select whole cells in the list...before you attempt a sort...Check out the
below link

http://www.contextures.com/xlSort01.html

If this post helps click Yes
---------------
Jacob Skaria


"Anil Mishra" wrote:

Is there any formula for data sorting? Because sorting a range of data change
the sequence of the original data . If there is a formula for sorting the
result of sorting could be seen on different range of cells without
disturbing the original data.