Weekly Challenge

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

A_Twa
8 - Asteroid

My solution attached; thanks!

MsBindy
8 - Asteroid

Yes, I can overcomplicate a ham sandwich.  Got there, but with all the condiments.

robcarroll
7 - Meteor

Solution. 

DaveB
Alteryx Alumni (Retired)

A different approach.

ADerbak
11 - Bolide

Tried to do a macro and couldn't quite get it to work right, went with tiling and formulas instead.

 

Solution attached!

nick_ceneviva
11 - Bolide

Solution attached!

jamielaird
14 - Magnetar

Here's my solution.

 

Edit: And yes, having looked at others I'm kicking myself for not doing the selection with a single formula tool - doh!

 

Spoiler
Untitled.png

 

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
Capture.PNG
Natasha
9 - Comet

Looking at other solutions, I guess I could do without a transpose.

 

Spoiler
Screen Shot 2017-09-20 at 00.14.53.png

 

data_rachel
8 - Asteroid
Spoiler
challenge19.PNG