World Cup calendar

[hstein]

Hello everyone, I want to to make an excel file for the Fifa World Cup, i'm only missing how to send the top two teams from each group to the knockout round (sheet 2). Basically I need to send the top two teams of each group, based on the points accumulated after 3 games, in case there is a tie, the second parameter should be goal difference, can anyone give me any ideas on how ca i do this? I have been stuck for a while now with this. And also, is there a way to sort the teams according to their points that doesn't mess up everything in the table?

Thanks

Mundial.xlsx

[XOR LX]

Hi,

You were just missing a bracket (and the one before the first IF is superfluous as well), e.g. for cell E2:

=IF(A12>C12,$I$2+3,IF(A12=C12,$I$2+1,IF(A12<C12,I2+0,I2+0)))+IF(C9<A9,$I$2+3,IF(A9=C9,$I$2+1,IF(C9>A9,I2+0,I2+0)))+IF(A15>C15,I2+3,IF(A15=C15,$I$2+1,IF(A15<C15,I2+0,I2+0)))

Regards

[hstein]

Hi,

You were just missing a bracket (and the one before the first IF is superfluous as well), e.g. for cell E2:

=IF(A12>C12,$I$2+3,IF(A12=C12,$I$2+1,IF(A12<C12,I2+0,I2+0)))+IF(C9<A9,$I$2+3,IF(A9=C9,$I$2+1,IF(C9>A9,I2+0,I2+0)))+IF(A15>C15,I2+3,IF(A15=C15,$I$2+1,IF(A15<C15,I2+0,I2+0)))

Regards

Thank you very much

[XOR LX]

You're welcome.

[shg]

I believe this does the same thing:

Please Login or Register  to view this content.