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

marcreid
7 - Meteor

Took the long way round on this one..

Spoiler
image.png
hoheusle
6 - Meteoroid
Spoiler
Spoilerimage.png

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
12 - Quasar

A good, easy break :)

dominiklz
8 - Asteroid
Spoiler
19.PNG
930realm
7 - Meteor

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
11 - Bolide

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

samN
10 - Fireball

Pretty simple

AT_12
7 - Meteor

Solution Attached


Tools Used:

 

- Tile > Method Unique Value

- Transpose

-Cross Tab

- Filter (Custom)

 

edorlando07
7 - Meteor

Challenge #19 has been conquered!

edorlando07
7 - Meteor