Standings

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

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
>
>