I am putting together an excel sheet for the World Cup standing for a
school project. I need to calculate the standings in each group. The
individual standings are based on point totals, but if the individual
points are the same for different teams then placement looks at goals
for; if that is not enough then finally goals against is calculated. I
am not sure what statement to use or if there is a calculation for this.
Please help!
Thanks!!

I have not been able to upload the spreasheet, but if you want to see
what I am talking about go the world cup website...

http://fifaworldcup.yahoo.com/06/en/w/group/index.html


--
sec97reno
------------------------------------------------------------------------
sec97reno's Profile: http://www.excelforum.com/member.php...o&userid=35543
View this thread: http://www.excelforum.com/showthread...hreadid=553050

Sort tables by:

Points
then Goal Difference
then Goals scored (Goals for)

My own version only sorts by the first two as probability of same points and
same goal is small. It would be easy to add in the third sort parameter.


"sec97reno" wrote:


I am putting together an excel sheet for the World Cup standing for a
school project. I need to calculate the standings in each group. The
individual standings are based on point totals, but if the individual
points are the same for different teams then placement looks at goals
for; if that is not enough then finally goals against is calculated. I
am not sure what statement to use or if there is a calculation for this.
Please help!
Thanks!!

I have not been able to upload the spreasheet, but if you want to see
what I am talking about go the world cup website...

http://fifaworldcup.yahoo.com/06/en/w/group/index.html


--
sec97reno
------------------------------------------------------------------------
sec97reno's Profile: http://www.excelforum.com/member.php...o&userid=35543
View this thread: http://www.excelforum.com/showthread...hreadid=553050