Hello,

Using Excel 2007

I would like a formula for 1st, 2nd, 3rd, 4th league positions in cells M5,M6,M7,M8 that displays the team name based on a league, firstly by the total points accumulated col J5-J8, followed by Goal difference (I5-I8), then lastly the Goals For (G5-G8)
.

I have attached an image showing the correct results edited by hand - but without the formula.
Any help greatly received.

Regards,
Iain...


I Soccer League Table.jpg