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 #36: Data Cleansing Extract Authors

joemkcarr
8 - Asteroid
 
Hannah_Lissaman
11 - Bolide

My solution :)

sagarb
8 - Asteroid

Using multi-row formulas

cgoodman3
14 - Magnetar
14 - Magnetar

Definitely done this with too many tools...

Spoiler
Challenge 36.PNG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
anaibeth
8 - Asteroid

Here's my submission 🙂 

challenge 36.PNG

myastarling
10 - Fireball

This challenge was *wonderful*. Here's why: there's ways of doing this, and there's efficient ways of doing this.

 

My original solution was 8 tools, but it took some 30 seconds to run. Why? Because I used the concatenate function of the Summarize tool. That gummed up all of the works. 

I took a peek at other people's solutions and then when whole hog on the multi row tool and it takes a mere second or two to run. 

I included both of them in the attached workflow.

Greg_Murray
12 - Quasar

Solution attached

smoskowitz
12 - Quasar

This one was fun, but adding in the old style icons messed me up. 😄

willdupre
7 - Meteor

Found this quite tough, and definitely could have been more efficient - but got there in the end and some good lessons learned.

sahinakos
8 - Asteroid