I have a 64 team tournament bracket created and was wondering if there is a way to create a button or write a formula to randomly pick names to fill out the bracket. Example would be to randomly pick either b4 or b6 and then paste that name/team into cell c5. I'm thinking it would be easier to do this round by round but if it would be possible to generate the entire tournament that would be even better.
Attached is my tournament file. Tournament.xlsx
Does this work: Sheet roster contains a list of names in column A and random numbers in column B. Column B is randomized and Columns AB sorted on B. The template sheet is filled sequentially from the sorted list top down.
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by protonLeah; 10-11-2014 at 02:20 AM.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks