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 #109: Women in Government Around the World

NilsM
8 - Asteroid
Spoiler
Challenge109.PNG
olivia_paquot
8 - Asteroid

Done !

jssandom
8 - Asteroid

Fun challenge!

paul_f
6 - Meteoroid

Nice logical steps

 

Spoiler
Challenge_109_solution.JPG
sann0638
8 - Asteroid

This was anonymised for us as an internal exercise, but I tracked it down!

Hoang7
6 - Meteoroid

My Solution:

Spoiler
109.JPG
CapriceW
8 - Asteroid

Here goes!

Calliecobbs
8 - Asteroid

Not the most elegant in the world but it works! 

Spoiler
Screenshot (237).png
kelly_gilbert
13 - Pulsar

I made this one a bit more complicated than necessary, because I wanted to make the workflow dynamic (in case we wanted to run this for different begin/end years).
Rather than creating an app, I just added two workflow constants to capture the begin and end years.

 

Spoiler
challenge_109_workflow.png
jwlong91
8 - Asteroid

Very fun challenge!  Love that multi-row formula tool!

 

Spoiler
Challenge 109.JPG