Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #191: BINGO!

DaisukeTsuchiya
13 - Pulsar
Spoiler
キャプチャ.JPGキャプチャ2.JPG

  

apathetichell
18 - Pollux

2021-05-30.png

So 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...

DataHabanero
9 - Comet

Ready, awesome and fun challenge!

sarahkelly
8 - Asteroid

Landed somewhere between Intermediate and Advanced on this one.

EW
11 - Bolide

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!  

 

Spoiler
I should say the first half of the challenge was fun!  The second half was table border and layout hell for me.  I need to learn the Reporting tools better to do these in a decent amount of time.  😬  191_EW.PNG
AndrewSu
Alteryx
Alteryx

my take 🙂

Qiu
20 - Arcturus
20 - Arcturus
Spoiler
challenge_191.PNG
Watermark
12 - Quasar
12 - Quasar
Spoiler
MT Solution 191.png

Original_Yodies
8 - Asteroid

completed as Beginner, to continue Intermediate with iterative macro soon.

Spoiler
Original_Yodies_0-1648055115997.png

 

LiuZhang
9 - Comet
Spoiler
191 - 1.png191 - 2.png191 - 3.png

Did Intermediate, tried Advanced, the format is just too hard 😂