Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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