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

JackBurnham
8 - Asteroid

b

j_trefethen
8 - Asteroid
Spoiler
Challenge 19 - JT solution.jpg

Not as simple as the provided solution!

jjrbondoc
8 - Asteroid
Spoiler
jjrbondoc_0-1625494971754.png

 

nravik
11 - Bolide

This was fun, thank you.

 

Spoiler
Spoiler!Wk #19.PNG
Jotigautam
10 - Fireball

My Solution:

Elias_Nordlinder
11 - Bolide

My solution:

Spoiler
Elias_Nordlinder_0-1626777992693.png

 

aravind_sk
8 - Asteroid

Not the optimal flow, but it works.

 

Spoiler
aravind_sk_1-1626843546312.png

 

johnyli168
Alteryx
Alteryx

Solution attached

BenFr
Alteryx
Alteryx

Imagine my solution could be more efficient, looking forward to looking through others!

Spoiler
BenF2_0-1627030550093.png

 

dfurlow
8 - Asteroid

slightly confused by the row numbers... wasn't sure if it meant 2nd row of the worksheet or 2nd row of the data...