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

nikhilnijhar
8 - Asteroid
Spoiler
Screenshot 2023-08-09 165035.png
Carolyn
12 - Quasar
12 - Quasar

I went with an Analytics App since I'm practicing with those (and why do something simple when you can make it complicated for no reason?). The user can select which row and columns to return. I also made copies of the first 2 files to have a few more files to play with

 

Spoiler
2023-08-10 17_14_51-Window.png

2023-08-10 17_15_06-Alteryx Designer x64 - challenge_19_start_file.yxwz.png

 

Krzysztof_Hyla_1986
8 - Asteroid

Good way to practice the 'Multi-Row Formula' tool

 

Spoiler
challenge_19_solution_KH.jpg

gawa
16 - Nebula
16 - Nebula

Done!

Spoiler
image.png
gawa
16 - Nebula
16 - Nebula

Post with solution file

ctrlvng
7 - Meteor

Here's my solution!

SJKIM
8 - Asteroid

Used Batch Macro

MDestra
8 - Asteroid

Challenge #19.

danielhoge
8 - Asteroid
Spoiler
Screenshot 2023-09-14 134155.png
Tgigs
8 - Asteroid

My solution attached