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 #221: Avocado Consumption

Greg_Murray
12 - Quasar

Solution attached

sanktiv
5 - Atom

Nice problem 🙂

SgdPackard810
8 - Asteroid

Multi-Row Formulas and Unions for the win! Love that 'cado toast.

RichoBsJ
11 - Bolide

Hi! Here my solution 🙂

 

Spoiler
CHALLENGE221.png
gurpe974
7 - Meteor

I chose a slightly different format to the solution's one. Looking forward to learn about more efficient approaches!

raychase
11 - Bolide

Challenge #221 is done!

 

Spoiler
raychase_0-1593268714055.png

 

EdE
7 - Meteor

My crazy solution is attached.  There are several much less complex and more clever solutions on the first page alone like @neilgallen@Kenda and @Aaron_Harter ....lots of fun and lots to learn for sure.  

PhilipMannering
16 - Nebula
16 - Nebula

**bleep** you percentage signs... always disappearing when I crosstab.

 

Solution Attached.

 

Spoiler
WorkflowWorkflow
VenkataP
7 - Meteor

Here is another solution using Tile tool.

HSmith001
5 - Atom

My first weekly challenge as just joined. any feedback appreciated.