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

BrianJohnson
8 - Asteroid

Thank you

Volha
7 - Meteor
Spoiler
Screenshot 2024-01-30 095114.png

Krzysiek
8 - Asteroid

MySolution

 

I deliberately dropped headers from xls spreadsheets as it makes more sense to me not to store them in analysis.

To achieve the same result as in the author's solution it would required to adjust formula for rows selection from 2 & 8 to 1 & 7 respectively.

 

I kept 2&8 as in the original exercise description, hence results are slightly different. but this solution works better for me,

 

christopher_ontkean
8 - Asteroid

Solution.

LiamHearns
7 - Meteor

LiamSolution019

 

1. Input file pulling in all values from Sheet1 c2

2. Input file pulling in all values from Sheet1 b8

3. Join

pmag
8 - Asteroid
Spoiler
image.png
danbostrom
8 - Asteroid

 

 

Manoj_k
8 - Asteroid

19/300

i have created small small macros to achieve the output.

gjjadhao
9 - Comet
Spoiler
spoiler#19.png

Solution is attached !!!

whitefang742
8 - Asteroid

For reference