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 #106: How Long were the Lights On?

Srinivasan_Bala
7 - Meteor

Solution attached

Erin
9 - Comet
Spoiler
I got stuck where my multirow formula wasn't accounting for all the duplicate people in a room at a time. Then saw the 2 tool solutions and mind blown. Such an easier way at solving.
Racam1989
7 - Meteor

Great use of the Multi-Row Formula tool here. Don't know if this is the most elegant solution, but it works.

 

Spoiler
Racam1989_0-1624338675309.png

 

pgneal
8 - Asteroid

My solution.  I think I went around the world to cross the street.

 

Thanks.

 

 

derekbelyea
12 - Quasar
Spoiler
derekbelyea_0-1624408748791.png

 

Nethrah24
8 - Asteroid

Done

ncrlelia
11 - Bolide

Challenge 106

Jonny
11 - Bolide

my solution:

 

Spoiler
Jonny_3-1625562613318.png
Jonny_4-1625562671392.png

 

 


 

 


 

Spoiler

 

beccat
8 - Asteroid

Solved it twice...first my longer method:

 

Spoiler
beccat_0-1626355844006.png

 

Then I used previous solutions to work on understanding the "two tool" solution (great way to learn!!):

 

Spoiler
beccat_1-1626355903617.png

 

IraWatt
17 - Castor
17 - Castor

Nice challenge, my solution:

 

Spoiler
IraWatt_0-1626430823740.png