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

KORKIS3
8 - Asteroid
Spoiler
KORKIS3_0-1671651052670.png

Simple Macro solution : )

spingili
8 - Asteroid
Spoiler
spingili_0-1671661878542.png

 

StanleyKinnok_Chan
8 - Asteroid

Here is my solution

boglarkalipka
8 - Asteroid

solved

danblythe
8 - Asteroid
Spoiler
Done :)
mkreddy
7 - Meteor

firstly i added the row numbers by multi row and then added nill to remaining values and finally grouped by file name

mkreddy_0-1672599577410.png

 

 

lhalliwell
8 - Asteroid
Spoiler
Screenshot 2023-01-03 101757.jpg

psk009
8 - Asteroid

#19: Nice exercise

 

psk009_0-1672754001864.png

 

olga_strubbe
11 - Bolide
Spoiler
olga_strubbe_0-1672757576818.png

 

olga_strubbe
11 - Bolide

I leveraged estherb47 solution, thank you, Esther!