sort columns without disturbing original selection please see sample file for more details

[Izhar]

sort column without disturbing original selection please see sample file for more details.

please provide a solution using formulas

 

[jayalaxmi]

See if this works for u..

regards,
Jaya

 

[Izhar]

thanks Jaya, i would need to do this on a fairly regular basis, can you please give me a short explanation as to how to go about this?

BR

 

[jayalaxmi]

ok what I had done is I had selected the data range and then applied filter to it and then selected the option as sort smallest to largest or vice versa...hope u got it...

Regards,
Jaya

 

[Izhar]

dear jaya,

this was my first attempt. however it does not seem work for me (may be i am doing it wrong)

please see attached result when i use the filters and sort it, the end result distorts the data in column C,

 

[jayalaxmi]

dear jaya,

this was my first attempt. however it does not seem work for me (may be i am doing it wrong)

please see attached result when i use the filters and sort it, the end result distorts the data in column C,

oh... k do u need that sorted file again???

 

[jayalaxmi]

dear jaya,

this was my first attempt. however it does not seem work for me (may be i am doing it wrong)

please see attached result when i use the filters and sort it, the end result distorts the data in column C,

don't worry it is not so complicated...give it a try once again u vl surely get it..

 

[Izhar]

confused! please see attached screen shots

 

[jayalaxmi]

have u first applied filter to it and then sorted it???

 

[Izhar]

yes

 

[jayalaxmi]

yes

ok I vl attach the sorted file again for u....