Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #62: Find the Duplicate Clicks

kat
12 - Quasar
Spoiler
Challenge #62.PNG
PrivateStorm
8 - Asteroid

My solution to challenge #62 is attached.

OllieClarke
15 - Aurora
15 - Aurora
Spoiler

challenge 62.PNG

Could be done in one tool, but hey

Gauthier_B
8 - Asteroid

That felt nice after the last one which had my brain boiling.

I am sure I could have made it in one tool, but could not manage to get my date formats right within the multi row formula.

 

Spoiler
Challenge 62 spoiler.PNG
OldDogNewTricks
10 - Fireball

Solution attached.

JDelgado
8 - Asteroid

My solution.

JoBen
11 - Bolide

Cheers!

Laurap1228
11 - Bolide

Short and sweet :)

MarMu
8 - Asteroid

 

Intermediate might be somewhat of a stretch to solve this one. :)

I solved the challenge using 2 tools. I guess one could have parsed the EventFireDate directly in the Multi-Row Formula tool, but for sake of simplicity, I went for the 2 tool solution.

 

Spoiler
challenge_62_start_file_MarMu.png
acrahen
8 - Asteroid
Spoiler
2018-10-15_10-45-02.png