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 #19: Excel Record Locator

cplewis90
13 - Pulsar
13 - Pulsar

Fun challenge! Curious to see how others solved this one!

Spoiler
Challenge 19.PNG
Moni
6 - Meteoroid
my solution
nikolaskardasis
8 - Asteroid
Spoiler
Capture.PNG
IgnasP
6 - Meteoroid
 
IJReed
8 - Asteroid
Spoiler
spoiler.PNG

👍

Benbryans
8 - Asteroid

This one thoroughly confused me but got there in the end with some help!

 

Just did the multi-row formula a bit different to the provided solution.

joshuaburkhow
ACE Emeritus
ACE Emeritus

There are many good applications for this one!

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
dpcurtis
7 - Meteor

I did it hard the first time, you are allowed to laugh.

Then I thought about it and ended up with the actual solution.

 

Yea Dave ! ! !

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 19 is done!

Spoiler
challenge 19 JMS solution.PNG
mambo
7 - Meteor

Here is my solution - I have a feeling that it could be more simply solved..