Start Free Trial

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

Dhrish
8 - Asteroid

Solution

Arran_S
8 - Asteroid

Attached

Endeavour
9 - Comet

Hi all,

 

Here is my solution.

Spoiler
Challenge_19.png

Thank you

vinspad
8 - Asteroid

Mine is a bit longer cuz I added a Regex to add a column. And I always add a sort at the beginning just to be sure.

erica_sch
7 - Meteor
Spoiler
SPOILER
JessicaEP
8 - Asteroid

Complete

AlteryxUser1
8 - Asteroid
Spoiler
AlteryxUser1_0-1758559263031.png

 

jrlindem
12 - Quasar

Another challenge that showcases how to do things in a less? traditional way.  For whatever the reason my machine would not play nice with the .xls file formats so I had to resave them as .xlsx but the concept is still the same.  A fun one to solve!

Spoiler
jrlindem_0-1758840157945.png

 

mirzaglamocak_alteryx
8 - Asteroid
Spoiler
mirzaglamocak_alteryx_0-1759274257664.png

 

SamHD
8 - Asteroid

This one was surprisingly hard.

Spoiler
SamHD_0-1759330743093.png