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

bhrmitra
10 - Fireball

Solution Attached !!

PrachiD
8 - Asteroid

Submission for ADV Challenge 19. solved using Tile tool

PrachiD
8 - Asteroid

updated Workflow

Hammad_Rashid
11 - Bolide

Challenge19.jpg

Amilley
8 - Asteroid

I believe that there is an issue with the current version of microsoft, I had to convert the files to XLSX vs xls, but I have solved.

 

 

Amilley_0-1679891988938.png

 

dougbaron
8 - Asteroid
Spoiler
dougbaron_0-1680010971124.png

 

jennifer_owens
8 - Asteroid

Given there were only two cells, I did two directories and joined them. Learned something new! 

gaoa
11 - Bolide
Spoiler
gaoa_0-1681185852405.png
NMangera
10 - Fireball
Spoiler
NMangera_0-1681208083982.png

 

TA

1. tool configuration: multi-row. reference the row position with the field name

2. design pattern: use the formula tool 'nullify' non-relevant values before using the summarise tool to extract values of interest with the max function

 

sp210708
8 - Asteroid

Less than ideal but it works!