Excel League Table

  • Thread starter Thread starter Kevin Hatcher
  • Start date Start date
K

Kevin Hatcher

hello All

i have been trying to produce a league table for football within excel
and have used some ideas found on this site. the idea is that the
league table is automatically updated as the scores are entered.

everything works fine until 2 teams have the same number of points.
this causes a team to appear in the league twice (or more depending on
how many teams have the same number of points). i have tracked this
down to the way the MATCH function works, but can't think of a way
around it.

here is an example of my spreadsheet
| a | b | c | d |
-------------------------
| 1 | liverpool | 5 | 4 |
-------------------------
| 2 | Everton | 3 | 4 |

column A=a unique number for each team
column B=team name
column C=Goal Difference
column D=Points

firstly i use the LARGE function to produce the points for each team
in descending order. lets assume the top score is put into cell D6

i then use LOOKUP(MATCH(D6,D1:D2,0),A1:A2,B2:B3) to produce the teams
name for that number of points.

however this only works if all teams have a different points total,
otherwise there is the same entry for both places in the league. in
reality if two or more teams have the same points the goal difference
field should seperate them.

does anyone know how i can get this to work?

i apologise if this is very confusing but it is hard to put in to
words

Thanks
 
Back
Top