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

nini
8 - Asteroid

My solution

Aidan_K
11 - Bolide

 

It has been a while since my last challenge ..... its good to be back :)

 

Here is my solution

thanks

Aidan

PhilBalderson
8 - Asteroid

All done.

PhilBalderson
8 - Asteroid

I like these easy tasks, because I always learn something! 

KeithTroutt
8 - Asteroid

solution

jdunkerley79
ACE Emeritus
ACE Emeritus

Made this one more complicated than it needed to be...

 

Spoiler
2019-01-18_22-40-06.jpg
Verakso
11 - Bolide

Must admit that I have skipped a few challenges, but the prior ones was still to turf for me at my current level, so this was nice and basic

Spoiler

So the obvious trick was to use a wildcard while reading in all the *.xls files.

I am just happy that we was not supposed to read in the other sheets, since there seems to be some major differences between .xls and .xlsx files, 

So this was my weekly challenge #30

 

Br
/Thomas 

Suzu
9 - Comet

Here is my solution.

TharunReddy
8 - Asteroid

2019-01-25 (4).png

rfergus
8 - Asteroid

Added some extra steps so I could reuse this later by having an input text with row and column names.

 

Spoiler
image.png