We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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...