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

smoskowitz
12 - Quasar

I did mine the hard way! But I say -- if you have a chance to practice with a macro -- then do so! :)

WH
7 - Meteor
Spoiler

1. Use multi-row to create Row Index
2. How to get a specific cell from excel sheet
2.1 transpose and locate the cell by row&column index, then cross-tab
2.2 use formula to set the unwanted cells in same row to null, then use summarize to get the maximum or only number in that row

Thableaus
17 - Castor
17 - Castor

Challenge #19, done.

 

Spoiler
Challenge19.PNG
sharathkumargurram1
7 - Meteor

Hi ,

 

Uploading the solution.

 

Best Regards,

Sharath Kumar Gurram.

Sajeel_Kershi
8 - Asteroid

Challenge 19 Completed

GiuseppeC
Alteryx
Alteryx

Differen solution to the 'official one', but same as @NicoleJohnson's one!

 

 

FeedMeData
8 - Asteroid

Here's my solve!

TonyA
Alteryx Alumni (Retired)

Spun my wheels for over an hour trying to figure out how to pull files from a directory. Once that was done this was easy.

hanykowska
11 - Bolide

That was rather interesting. I'm not sure whether my aggregation makes sense, but it worked in this case.

JonathanAllenby
8 - Asteroid

Here's my solution to challenge 19!