sorting big time

  • Thread starter Thread starter vak001
  • Start date Start date
V

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;
 
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
 
Back
Top