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

This was really informative exercise, I learned to connect multiple files without increasing the inputs

For this exercise, I had to learn about the Tile function. Without it, I wonder how else you can solve this.

Thanks

Soln

Challenge 19.png

Ready!

Tricky at first for me as I still do not master the multi field formula but it was a nice one to get better while using it.

Spoiler

#19 - Solution - PS.JPG

I didnt understand the question properly so peeked at the solution to understand what he is asking. Anyway import the sheets, use multirow formula to collect row2_col3 and row_8 Col2, then select the column, summarize and choose the max of the field values.

My Solution. I make 2 pattern.

curated machine learning resources