We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #267: To Quote The Alphabet

AngelosPachis
15 - Aurora

My solution to this week's challenge. Played quite a bit with the multi-row formula tool, I'm sure there should be a more efficient way to flag/filter out consecutive letters 🤔

 

Spoiler
AngelosPachis_0-1620753608181.png

 

kelly_gilbert
12 - Quasar

Thank you, @dylan_gao, this one was super fun (and challenging!) I am really looking forward to looking at all of the different solutions this week. 

 

Spoiler
kelly_gilbert_0-1620769306806.png  

 

kelvinlaw
8 - Asteroid

Here is my solution:

Spoiler
kelvinlaw_0-1620784074737.png

 

scallybrian
5 - Atom
Spoiler
scallybrian_0-1620833784679.png

 

DN
8 - Asteroid
Spoiler
Capture.PNG

italoteixeira_
5 - Atom
Spoiler
spoiler.PNG
SJAng
6 - Meteoroid

done

OllieClarke
13 - Pulsar
13 - Pulsar

Didn't know there was a longest action in a summarise tool

 

Spoiler
OllieClarke_0-1620897038604.png

 

ArtApa
Alteryx
Alteryx

Here is my solution

Spoiler
ArtApa_0-1620902244394.png

 

sprodger
8 - Asteroid

 

Spoiler
sprodger_0-1620909969477.png