Free Trial

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 #286: Who turned the lights off?

elenapoon
7 - Meteor

My solution!

mithily
8 - Asteroid
Spoiler
nice use of the find and replace tool
Mahmoud_Nasser94
7 - Meteor

I don't think this solution is more accurate because some Animals exist in the Article title column but end with s, so ur solution ignored it.

 

Capture.PNG

 

 

CBarito
8 - Asteroid

🐄

ctrlvng
7 - Meteor

Here's my solution!

tchakir
7 - Meteor
 
Spoiler
 

 

AndreeaS
8 - Asteroid
Spoiler
Screenshot 2023-07-15 155855.png
TOMBOB
7 - Meteor

challenge 286.png

josedlr00
8 - Asteroid

It took me a while to figure out but I did. 

CMWalsh
8 - Asteroid

Had a false start with this one...

Spoiler
...using Append and a formula - Find and Replace is the better solution, far easier to prevent 'bobcat' being counted as 'cat' etc.
AWC_286_screengrab.png