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

mollymargolis
8 - Asteroid

my solution

AnaisComyn
9 - Comet

Done !

Per
11 - Bolide

Not much to it 🙂

nelsoer
6 - Meteoroid

Here are 2 methods, one method using Group by/Max and one method using Crosstab and Join.

JethroChen
10 - Fireball
Spoiler
challenge_19_jc.PNG
Milanz
8 - Asteroid

Useful!

Spoiler
Milanz_0-1597129948198.png

 

 

p_padham
8 - Asteroid

Hi!

 

Here is my attempt:

 

Spoiler
challenge19_complete.png
lauren83
7 - Meteor

6th challenge complete 🙂

bkwilson
7 - Meteor
Spoiler
ch19.PNG
lmatthewsii
7 - Meteor
Spoiler
 

DOne.