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

Challenge #235: Spell It Out For Me - Part 2

dsmdavid
11 - Bolide

Fun challenge, thanks!

I tried to steer out of longwinded formulas.

Spoiler
The macro requires 3 columns, to process as hundreds, tens and units.dsmdavid_2-1601824992398.png

 


dsmdavid_1-1601824923518.png

 

 

Emil_Kos
17 - Castor
17 - Castor

Hi,


This was super time consuming but I finally made it:

 

Spoiler
Emil_Kos_0-1601833201654.png

 

JustinBabbitt
Alteryx
Alteryx

ugh... too me too long to get through this one! But I'm happy with how few tools I used.

 

Spoiler
JustinBabbitt_0-1601910432906.png

 

Justin Babbitt
AngelosPachis
16 - Nebula

My solution for challenge #235

 

Spoiler
Screenshot 2020-10-05 164709.jpg
hanykowska
11 - Bolide

I recorded myself solving the challenge (not just going through the explanation but as I was solving it), and I know it took me well over an hour - although it did take extra time to explain a few of my thoughts... Edit will be coming any time now!

 

I've built on my solution for 234 challenge so it might be slightly different but I'm quite happy with how it turned out. 

Spoiler
solution documented cropped.png
Tokimatsu
12 - Quasar

Solved.

Spoiler
2020-10-06_18h45_35.png

jeng
8 - Asteroid

Learnt something about the find and replace tool....

 

Spoiler
jeng_0-1602057461977.png

 

Milanz
8 - Asteroid

wow....

Spoiler
Milanz_0-1602080136487.png

 

JoshuaGostick
11 - Bolide

My solution

 

Spoiler
challenge_235.PNG
johnemery
11 - Bolide

Very fun and unique problem! I imagine I could be more elegant here, but overall I'm pleased with my solution.

 

Spoiler
Capture.PNG