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

jnans
8 - Asteroid

In looking at some of the others after I did this and right before I posted I feel like I went at this from a very complicated view but then again there are a million different ways in which once can achieve the same result.

Challenge_19_jnans.PNG

 

joemkcarr
8 - Asteroid
 
justindavis
10 - Fireball

I ended up changing the file types to .xlsx due to issues with drivers related to reading in .xls files.

Spoiler
challenge_19_solution_justindavis.PNG
Hannah_Lissaman
11 - Bolide

My solution :)

IvyM
7 - Meteor
 
myastarling
10 - Fireball

Another fun Challenge! What I love about this one is how very different everyone's solutions were. I saw at least one person used a tile tool -- I never would have thought of that!Capture.PNG

tochy
8 - Asteroid

19SolutionTochy.JPG

 

vivekgaur
5 - Atom

May not be the most optimal solution but I was able to get to the desired result :)

 

2019-06-20_20-46-06.png

papalow
8 - Asteroid

A good reminder to keep things simple.

phottovy
13 - Pulsar
13 - Pulsar

I'm curious to see everyone else's solutions for this one.