League Ladder refinement of Sorting.
 

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

League Ladder refinement of Sorting.
 

Hi Adeptus,

Perform two sort operations: sort by the three least significant columns and
then sort by the three most significant columns.

---
Regards,
Norman



"Adeptus - ExcelForums.com" wrote
in message ...
Hello all!

What I have is a league ladder that has scores in 6 different
categories.

Fistly I want to sort them so that they are sorted in order from the
first category to the last -
however i've found that the normal sort function doesn't allow for
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 did
the sort for 3 categories, and then went through and had maybe an If
command or checked to see if there were any same values in the 4th
category. if there were, it could then run a second sort, ONLY on
the ones that have the same values.

I'll try for an "actual" example. Based only on being able to sort 3
Columns.

Column A, B and C all have numberical scores in them and are all
sorted in descending order. It sorts the data by A, then by B, then
by C.

However once this is done there is a problem. Four people in the
ladder have the same scores for A, B and C. ANd another group of 4
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 then
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, E
and F also.


IS this possible. if yes, how can I write the code for it.