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
A solution to last week’s challenge can be found here.
This challenge was submitted by Ashley Talay, @aatalai. Thank you, Ash, for this delightful seasonal puzzle!
As the snow begins to fall and the year comes to a cozy close, it’s the perfect time for a bit of holiday fun. While the Elf on the Shelf is busy reporting back to Santa, another mischievous character has gone missing...
Waldo (or Wally, depending on where you’re celebrating) has snuck off for a little hide-and-seek adventure. Guess where? Inside an Excel folder, of all places!
He's somewhere deep within the "Places" directory, but he’s layered himself under folders, subfolders, and buried sheets, a classic Waldo move. We don’t know:
- Which folder he's in,
- Which subfolder he chose,
- What file he’s hiding in,
- Or even which sheet he’s nestled on.
Your mission (should you choose to accept it under the twinkling lights of December):
Find Waldo!
Dig through the maze of folders and spreadsheets, and tell us exactly where he is hiding:
- Folder
- Subfolder
- File name
- Sheet name
If you feel it’s time to showcase your macros skills, you can level up and dive even deeper.
Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.
Good Luck!
The Academy Team
First off, I’m not willing to admit how long it took me to realize there was a second Zip download… here I am thinking, “seriously where ARE the Waldo files…”
Okay then, I went the route of Input Tool instead of Directory Input. Cache’ing the data is your friend here. The rest I’ll leave to the spoiler tag!
Whenever I have the chance to use the REVERSE() function, I seem to gravitate to it... in this case I used it to parse the file, subfolder, and folder.
Did not save my solution as a package. You'll need to place the attached file in the same location as the "Places" folder and contents for this to work.
This was a fun challenge! Solution above and attached.
