Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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.