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 #1: Join to Range

Anood
7 - Meteor

Attached my solution.

igorp
8 - Asteroid
Spoiler
igorp_0-1586447103381.png

 

mopurv
6 - Meteoroid

Here is my solution:

 

 

Vishnu_Sekhar
7 - Meteor

Challenge 1 Solution

LuciaC
7 - Meteor

2 solutions:

 

first solution: using  only "core" tools from the interactive lessons

second solutions: I did all the configurations on my own but I saw the "generate rows" tool (new to me) in another user's solution screenshot so I didn't come up with the solution entirely on my own

MOHAMMEDAFZAL
7 - Meteor
Spoiler
MOHAMMEDAFZAL_0-1586637888829.png

 

My Solution 🙂

Sudha8990AI
8 - Asteroid

Join Range by using cell level formula.

Siegerbesieger1992
6 - Meteoroid

solution

Chiaroscuro
6 - Meteoroid

Hi! This is my 2nd Weekly Challenge! I answered a Beginner Challenge before answering this first challenge.

 

Spoiler
In my solution, I used Find Replace Tool although the title of this challenge is "Join to Range".
Is this still acceptable?
joshvbarth
8 - Asteroid
Spoiler
joshvbarth_0-1586872084298.png