League Ladder refinement of Sorting.

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.

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" <Bensquig@hotmail-dot-com.no-spam.invalid> wrote
in message news:OKE3OCKnFHA.3936@TK2MSFTNGP10.phx.gbl...
> 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.
>