It's beginning to look a lot like...Advent of Code! Get in the holiday spirit by learning how you can participate in this friendly competition and earn a seasonal badge.

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

jpg34
7 - Meteor

my solution

AImbody
8 - Asteroid

My solution is below.  

JXEC
7 - Meteor

Was pretty easy, just had to make sure of the finer details.

DQAUDIT
9 - Comet

Solution attached.

afnfyz
8 - Asteroid

Tackled this a bit differently.

Spoiler
Used the wildcard on the file name but then also specified the specific value within the query so the output is only the value that was asked for in the prompt.
Did this for both the values and then just joined based on position.
Screenshot 2023-10-21 213504.png

 

flavio-matos
7 - Meteor

Here's my solution

Spoiler
19.png

 

 

RasmusFormo
8 - Asteroid

My solution :)

DaisukeTsuchiya
13 - Pulsar
Spoiler
スクリーンショット 2023-11-10 093809.png

AndrewDMerrill
12 - Quasar

It seems that I over-complicated things a tad.

Spoiler
Workflow.png
ds_tomalexsmith
8 - Asteroid
Spoiler
Challenge 19 (flow).png