sport tables

  • Thread starter Thread starter Peldo
  • Start date Start date
P

Peldo

Hello,

I have created a table according to football european championships in
Portugal. There is a rule that when teams have equal points the order is
based on the games played against each other. My sheet has all the matches
played,e.g. sweden 1 1 italy, and from that information automatically a
table is sorted for each group by criteria points, goal difference and goals
made. I just can't find a way to automatically sort according games between.
Is there anyone that could help or has found a solution for such a problem?

The same problem is with my Formula 1 table. On equal points how to find the
order based on the previous results for the driver.

Any help is much appreciated,
Peldo

p.s. the rule was used in group c (Sweden, Denmark, Italy equal in 5 points
and Bularia 0 points)
 
Hi

It really depends on how your table is laid out and how you do your existing
calculations. Some of the Euro 2004 spreadsheets I've seen use loads of
extra calculation sheets - which aren't really necessary. One way to solve
your problem is to create a table (hidden) that calculates each team's goal
difference against each of the other teams in the group. Then it's a case of
adding the relevant values together.
 
Back
Top