Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

olivia_paquot
8 - Asteroid

Done :-)

simonpain
5 - Atom

I first did it using a bit of python 'cos I'm a developer so that's how I think but that felt like cheating so after having a sneaky quick look at some of the other answers layouts I tried a cross-join approach.

 

Spoiler
Challenge135.png

 

DawnR
8 - Asteroid

Learning new things today.

lminors
9 - Comet
Spoiler
Great opportunity to refresh the iterative macro skills.
Capture.JPG
GarthMiles
7 - Meteor

only requires 1 tool

Spoiler
Screen Shot 2018-10-22 at 10.39.37 AM.png
petgrap
8 - Asteroid
Spoiler

challenge_135-PP.JPG

 

 
richard_butler
6 - Meteoroid

Ran query with a join rather than a macro to see if it would be quicker

jezknee
7 - Meteor

Solution attached. This was a particularly satisfying weekly challenge.

Carlithian
11 - Bolide
11 - Bolide

Tricky getting my head around the iterative macro, lots of fun though

estherb47
15 - Aurora
15 - Aurora

Really getting the hang of iterative maros :)

Spoiler
The workflow:
image.png

The Macro:

image.png