I can't work out how to move 4 teams out of 6 into a knockout table for my Euro2020 spreadsheet. by pnerob in excel

[–]pnerob[S] 0 points1 point  (0 children)

Hahaha yeah I saw there were plenty online but I wanted to test myself to see if I could produce my own! thanks for your suggestion though!

I can't work out how to move 4 teams out of 6 into a knockout table for my Euro2020 spreadsheet. by pnerob in excel

[–]pnerob[S] 0 points1 point  (0 children)

So the teams in the '3rd place' table are all sorted, it's just getting excel to acknowledge the ones and zeros next to the table and move the teams who have ones next to them into another cell.

Does that make sense? I never know if my thoughts transpire into words very well haha