Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

Solved it using filter condition to label rows, and then summarized it.

Not the most elegant, but gives the required output.

Vamsi

Finished

Finished.

I think this is how you are supposed to do these challenges and get credit for it. Well here is my answer, anyway.

Here is my solution.

Well better late than never so see attached.

Here is the solution for Challenge 1

Challenge #1: Join to Range