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
Asteroide

b

j_trefethen
Asteroide
Saqueador
Challenge 19 - JT solution.jpg

Not as simple as the provided solution!

jjrbondoc
Asteroide
Saqueador
jjrbondoc_0-1625494971754.png

 

nravik
Bólide

This was fun, thank you.

 

Saqueador
Spoiler!Wk #19.PNG
Jotigautam
Bola de fogo

My Solution:

My solution:

Saqueador
Elias_Nordlinder_0-1626777992693.png

 

aravind_sk
Asteroide

Not the optimal flow, but it works.

 

Saqueador
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!

Saqueador
BenF2_0-1627030550093.png

 

dfurlow
Asteroide

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