Sorting Tied Teams in League Table by Matches Between Themselves

N

Neil Pearce

I have organised a softball league for a set of companies. The league is
such that there are 2 points for a win, 1 for a draw and 0 for a loss.

There are 24 companies split into 4 groups of 6. Each company plays the
other teams in their group once with the top two of each progressing to the
1/4 finals.

The group placings are decided on points accumalated. Subsequent deciders
are then the results between the teams tied on the same points, the number of
wins, then games played (not all teams will arrange all their fixtures), and
finally nett runs scored (runs for minus runs against).

Two problems have arisen from creating this in Excel:

1. Excel appears to only enable me to sort by than 3 items. Is there a way
to increase this?

2. Sorting by more points, number of wins, games played, and nett runs is
easy. Sorting between two teams by result is achievable. However I'm
struggling when more than two teams are tied on points, or there are two sets
of two teams tied on different points totals within the same group.

Any ideas?


Thanking you in advance,

Neil
 
Y

Yanick

Use all 3 criterias, then keep the result by creating a indicator in a new
colomn. (number from 1 to x). Then sort that colomn (representing the result
of a 3 colomn sort) with 2 more.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top