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
クエーサー

Solution attached

sanktiv
アトム

Nice problem 🙂

SgdPackard810
アステロイド

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

RichoBsJ
ボリード

Hi! Here my solution 🙂

 

スポイラ
CHALLENGE221.png
gurpe974
メテオール

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

raychase
ボリード

Challenge #221 is done!

 

スポイラ
raychase_0-1593268714055.png

 

EdE
メテオール

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.

 

スポイラ
WorkflowWorkflow
VenkataP
メテオール

Here is another solution using Tile tool.

HSmith001
アトム

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