Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

Jur
7 - Meteor

My solution:

 

Spoiler
Challenge_19_JP.png
Niklas
8 - Asteroid

Almost got it to work completely with dynamic input but had to go for a work-around to append the sheet names 😕

SophiaF
Alteryx
Alteryx

Multi-row Formula!

 

Spoiler
clipboard_image_0.png
Sophia Fraticelli
Senior Solutions Architect
Alteryx, Inc.
FRANCK_ROUQUETTE
8 - Asteroid
Thank you for the exercise - please find attached my proposed solution.
LukaszKarpinski
8 - Asteroid

Hi! My solution in the attachment,

 

Kind Regards,

Łukasz

ConradW
8 - Asteroid

19- complete

SarkaHubacek
8 - Asteroid

I decided to take this challenge as an opportunity to learn as much as possible, so I tried different approaches showed here.

 

Spoiler
Screen Shot 2019-08-15 at 3.55.48 pm.pngScreen Shot 2019-08-15 at 3.56.08 pm.png
Tom_Luthi
8 - Asteroid

solution attached.

viveknshah
8 - Asteroid
Spoiler

Pretty similar to other approaches looks like, only I used ordinal ordering like arrays so had to go with 1 and 7 instead of 2 and 8. 
challenge19_viveknshah.JPG
Inactive User
Not applicable

clipboard_image_0.png