ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more 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

Waynemk
Asteroide

and another

ggruccio
ACE Emeritus
ACE Emeritus

More steps than I thought it would take, but got there.

Amarendra
Bola de fogo

Uploading my solution for this. I think it only works for the given problem but is not a universal solution. 

LandonG
Asteroide

My solution.

PhilipMannering
16 - Nebula
16 - Nebula

Simple as you like...

 

Saqueador
challenge_19 - Snip.PNG
jasperlch
Quasar

Solution attached.

blairmbailey
Asteroide

Solution attached - thank you!

aclaxton
Asteroide

Had to change file type to .xlsx due to windows security, but I think this is as simple as it gets...

Saqueador
Week 19.png
MBark
Meteoroide

Definitely learned some new tricks here. 

BrendaS
Asteroide

Here is my answer