This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackSo it's an app. two batch macros, and an iterative macro. I realized I should used a random sample tool instead of the iterative macro but at the time that seemed like the easiest solution to the "how do I choose a random item and prevent that item from begin chosen a second time" problem... So app takes in the number of cards wanted. Control/Batch deals with layout and calls the batch for the different card type. Second batch controls the iterative part - which is basically just a random % sample tool but oh so much more fun...
This challenge was so much fun! Reminds me of one of the first Excel macros I ever wrote, to generate random BINGO cards based on stuff a certain friend always said!
completed as Beginner, to continue Intermediate with iterative macro soon.
Did Intermediate, tried Advanced, the format is just too hard 😂