Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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 #323: Analyze books Availabilities

tanyafischer
8 - Asteroid

solved :)

chukleswk
11 - Bolide

Perfect use case for several multi-row formulas!

Spoiler
Capture.PNG

Gebi
7 - Meteor

This is my solution for the challenge #323

FilipR
11 - Bolide

Solved.

 

Spoiler
FilipR_0-1657267640525.png



Probably too much sorting to get it right.

Brian32
8 - Asteroid

Challenge Solution.

In the given output, the Reason for each day appears to be in a backward order.

ferg_smith
8 - Asteroid
Spoiler
ferg_smith_0-1657727981589.png

 

lynnesonneyrsm
8 - Asteroid

Apparently the only way my brain could solve consecutive days was with a batch macro. 

MohithRai
8 - Asteroid

Done 🚀

Spoiler
MohithRai_0-1657869845560.png

 

 

Eswaran
8 - Asteroid

Capture.PNG

CandiceDB
Alteryx
Alteryx

My solution 😊

 

Spoiler
CandiceDB_0-1658173475641.png