Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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

igorp
8 - Asteroid
‎10-03-2020 10:54 AM

A bit different approach

 

Spoiler
igorp_0-1601747631423.png

 

 

 

challenge_19_igorp.yxmd
Reply
0 Likes
rajatsadan
8 - Asteroid
‎10-04-2020 06:14 AM

Solved!!

challenge_19_soln_rajatsadan.yxmd
Reply
0 Likes
LGFAnalyst
6 - Meteoroid
‎10-04-2020 09:43 AM

I used SUM instead of MAX in my summarize and I got the same result, The tricky part for me was the multi-row formula, definitively need to practice those some more. 

 

 

challenge_19_LGF.yxmd
Reply
0 Likes
stellarstevey
7 - Meteor
‎10-10-2020 02:25 PM

Solution attached.

challenge_19_SA_Solution.yxmd
Reply
0 Likes
sunny430
7 - Meteor
‎10-10-2020 08:23 PM

My solution:

challenge_19_sunny430.yxmd
Reply
0 Likes
Sashikumar
8 - Asteroid
‎10-13-2020 07:47 AM

Cool.

Spoiler
ch19.PNG
challenge_19_start_file_sk.yxmd
Reply
0 Likes
wardboston
7 - Meteor
‎10-13-2020 09:42 PM
Spoiler
Solution
wardboston_0-1602650519737.png

 

challenge_19_solution_ashwin.yxmd
Reply
0 Likes
Hamza21
7 - Meteor
‎10-13-2020 10:45 PM

my solution

challenge_19_start_file.yxmd
Reply
0 Likes
p-g
8 - Asteroid
‎10-15-2020 02:26 AM
Spoiler
My Solution:
19-Challenge Solution 2020-10-15 144633.png

 

Reply
0 Likes
greggrimmer1
8 - Asteroid
‎10-22-2020 05:38 AM
Spoiler
greggrimmer_0-1603370272356.png

 

challenge_19_completed.yxmd
Reply
0 Likes
Live Weekly Challenge