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
SOLVED

Challenge #135: Locker Problem

AlexC2
8 - Asteroid

nice challenge

grazitti_sapna
17 - Castor

Hi, Solution to Challenge 135.

 

Sapna Gupta
phottovy
13 - Pulsar
13 - Pulsar

Good macro practice! I also think this is completed challenge #100 for me. I'm slowly catching up to the Top Challengers.

Spoiler
135a.PNG
135b.PNG
Spalders
8 - Asteroid
Spoiler
Spalders_1-1598627548319.png

 


 

AkimasaKajitani
17 - Castor
17 - Castor

My Solution. I used Binary operation in Iterative Macro. This challenge is fun.

 

Spoiler
Workflow
AkimasaKajitani_1-1599273127556.png

 



Iterative Macro
AkimasaKajitani_0-1599272999793.png

 

mithily
8 - Asteroid

elegant, lovely simple solution!

rayJ
8 - Asteroid

Awesome practice for Iterative Macro. Took me a morning to solve the problem.

Spoiler
rayJ_0-1600120567056.png

Workflow

rayJ_1-1600120595320.png

Macro

JethroChen
10 - Fireball
Spoiler
challenge_135_jc.PNG
mithily
8 - Asteroid

finally got over my fear of iterative and batch macros. I tried to do this as a batch macro but got weird results. Realized this is not a batch macro but an iterative macro. Still wish I could do it as a batch macro.... Did it two ways, once with a generate rows option and once with a created input file  that I created in excel. Still wondering why the batch macro did not work......

collinalldata
7 - Meteor

Here's my solution!