Challenge #19: Excel Record Locator

[deepaprash]

Done.

[liamholland]

Solution:

Spoiler

[Brad4Data]

I have done this exercise before.  The solution is much better with this challenge.  

Spoiler

Input tool with a wild card (book*.xls).  Added a row number with the multi-row and then created formulas to get each row/col combo.  Grouped by Filename and max of each field.  

[JohanRanschaert]

in attach my solution

[cc000072]

Here is my solution

Spoiler

[Lucatelli]

Please find attached my proposed solution.

[Sylvana]

My solution

Spoiler

[dpencheva]

Here is  my solution. I tried to make it simple. ; )

[JunePark]

Spoiler

[DanielLing]

Way longer than solution but it got there!!

Learned a neat trick along the way from the solution too.