Hi, I'm struggling with a spreadsheet i'm doing at the minute.
I've got a football tournament with 4 groups of 4 at the minute
I've done this so the top team goes through to the knockout stage from each group, located in G14, G34, G54 and G74
I've also done the 2nd team in each group to go through which are located in G15, G35, G55 and G75
I want the knockout quarter final to randomly draw 1st placed team against a 2nd placed team
Is there any chance I can get some help please?
I've got a football tournament with 4 groups of 4 at the minute
I've done this so the top team goes through to the knockout stage from each group, located in G14, G34, G54 and G74
I've also done the 2nd team in each group to go through which are located in G15, G35, G55 and G75
I want the knockout quarter final to randomly draw 1st placed team against a 2nd placed team
Is there any chance I can get some help please?
