Challenge #19: Excel Record Locator

[adam_speed]

another great learning exercise.  can see some potential real world uses here :)

Spoiler

[brette]

need to remember there is always a simple solution.  need to remember wildcarding in inputs before you go down the rabbit hole which can be developer tools.

[lukas_olsovsky]

Hello, I tried different approach with using input tool to its maximum possibilities.

Take a look and let me know. (@GeneR)

Running time 0,7sec.

Spoiler

[LuisLeon]

Solution!

[Skarthikak]

[Rhys_Cooper]

Useful challenge for loading sheets without using a batch macro. Interestingly couldnt get the output to match with the answer, was always 1 number larger. Manually inspecting the xls files shows my answer is correct according to the dowloaded files.

Spoiler

[Arran]

Awesome

[nSpire]

Spoiler

 

[Anee]

Solved

[mshishido]

hre