A
Adeptus - ExcelForums.com
Hello all
What I have is a league ladder that has scores in 6 differen
categories
Fistly I want to sort them so that they are sorted in order from th
first category to the last
however i've found that the normal sort function doesn't allow fo
more than 3 categories... is there a way around this
If there is a possibliltly of being able to sort as much as you want
then ignore the rest of this post
+++++++++++++++++++++++++++++++++++++++++++++
If there isn't I thought that I could perhaps have some code that di
the sort for 3 categories, and then went through and had maybe an I
command or checked to see if there were any same values in the 4t
category. if there were, it could then run a second sort, ONLY o
the ones that have the same values
I'll try for an "actual" example. Based only on being able to sort
Columns
Column A, B and C all have numberical scores in them and are al
sorted in descending order. It sorts the data by A, then by B, the
by C
However once this is done there is a problem. Four people in th
ladder have the same scores for A, B and C. ANd another group of
further down have the same scores as each other
(This is where I want to do the check
The Macro then checks and finds the first group of people. It the
selects their entries and sorts them by the remaining categories
sort by Columnd D, then E and then F
Then it continues and finds the second group and sorts them by D,
and F also
IS this possible. if yes, how can I write the code for it
What I have is a league ladder that has scores in 6 differen
categories
Fistly I want to sort them so that they are sorted in order from th
first category to the last
however i've found that the normal sort function doesn't allow fo
more than 3 categories... is there a way around this
If there is a possibliltly of being able to sort as much as you want
then ignore the rest of this post
+++++++++++++++++++++++++++++++++++++++++++++
If there isn't I thought that I could perhaps have some code that di
the sort for 3 categories, and then went through and had maybe an I
command or checked to see if there were any same values in the 4t
category. if there were, it could then run a second sort, ONLY o
the ones that have the same values
I'll try for an "actual" example. Based only on being able to sort
Columns
Column A, B and C all have numberical scores in them and are al
sorted in descending order. It sorts the data by A, then by B, the
by C
However once this is done there is a problem. Four people in th
ladder have the same scores for A, B and C. ANd another group of
further down have the same scores as each other
(This is where I want to do the check
The Macro then checks and finds the first group of people. It the
selects their entries and sorts them by the remaining categories
sort by Columnd D, then E and then F
Then it continues and finds the second group and sorts them by D,
and F also
IS this possible. if yes, how can I write the code for it