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
Bolide

Fun challenge, thanks!

I tried to steer out of longwinded formulas.

Révélation
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:

 

Révélation
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.

 

Révélation
JustinBabbitt_0-1601910432906.png

 

Justin Babbitt
AngelosPachis
Nébuleuse

My solution for challenge #235

 

Révélation
Screenshot 2020-10-05 164709.jpg
hanykowska
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. 

Révélation
solution documented cropped.png
Tokimatsu
Quasar

Solved.

Révélation
2020-10-06_18h45_35.png

jeng
Astéroïde

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

 

Révélation
jeng_0-1602057461977.png

 

Milanz
Astéroïde

wow....

Révélation
Milanz_0-1602080136487.png

 

JoshuaGostick
Bolide

My solution

 

Révélation
challenge_235.PNG
johnemery
Bolide

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

 

Révélation
Capture.PNG