sorting big time

[vak001]

hi guys

i have a sreadsheet with 5 colunms
i need them to be sorted
by acending order of colunms 1
then colunm 2
then colunm 3
then colunm 4
then colunm 5

i guess u see the problem by now ;
exel won't let me do this for more than the 3 first colunms

can any1 help please

thanks;

 

[vak001]

sorry

http://www.dicks-blog.com/excel/2004/06/sort_on_more_th.htm

 

[agarwaldvk]

One other way of getting around this is :-

In an intermediate column say column F, concatenate the values of eac
of the columns that you want to sort your data by.

For example, if you want to sort your data by column E within column
within column C within column B within column A, enter the followin
formula in the first row of your data set in column F as follows :-

=concatenate(A1,B1,C1,D1,E1)

Then, copy it down all the way down covering the entire range of you
data set.

Now sort your data by column F


Best regards



Deepak Agarwa