In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

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

brianfia
8 - Asteroid
Spoiler
challenge_19_solution_brianfia.PNG
m-wolters
8 - Asteroid

My solution

DataKilroy
8 - Asteroid
Spoiler
DataKilroy_0-1653494772390.png

 

AishaAnwar
6 - Meteoroid

My solution seems very clumsy and long winded versus most of the other replies!

 

Spoiler
AishaAnwar_0-1653582457325.png

 

Jeremy
8 - Asteroid

Now that I've looked at the solution, this isn't the most efficient way to handle this, but it works.

Spoiler
2022-05-30_16-59-24.png
mmontgomery
11 - Bolide
11 - Bolide

Challenge #19

罗颜塔尔
7 - Meteor

_0-1654072790521.png

 

mark007
8 - Asteroid

Solved!  Is there a better way of selecting a particular row and column as this seems laborious....

 

 

acarter881
12 - Quasar

Here's my solution.

Spoiler
my_weekly_challenge_19_solution.png
bold3d
8 - Asteroid

My solution challenge #19