community Alteryx IO Alteryx.com
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
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
curated machine learning resources