Challenge #19: Excel Record Locator

[marcreid]

Took the long way round on this one..

Spoiler

[hoheusle]

Spoiler

Spoiler

I first used the record ID tool, but that doesn't work since you need to restart at 1 for a new file name. Within the Multi-Row Formula, this can be quickly done by grouping by FileName. Helps simplify the expression. 

[JoshKushner]

A good, easy break :)

[dominiklz]

Spoiler

[930realm]

Had to change the file format to xlsx because I kept getting an error trying to open the xls. I thought I would be able to use the sql to bring back the fields, but it looks like I can only bring in sheet names and named ranges. All in all it looks like my solution is similar to others.

[dsmdavid]

MultiRow showing the limitations of the Record ID tool...

[samN]

Pretty simple

[AT_12]

Solution Attached

Tools Used:

- Tile > Method Unique Value

- Transpose

-Cross Tab

- Filter (Custom)

[edorlando07]

Challenge #19 has been conquered!