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

Anmol97
8 - Asteroid

Here's my solution.

brandowd
8 - Asteroid

Hi @GeneR,

 

I got the same answer but I prefer the method used in the solution as seemed a bit simpler than mine.

 

Spoiler
brandowd_0-1631086055926.png

 

msalem
7 - Meteor

My solution

simon_inviso
8 - Asteroid

My solution (Spoiler)

Harrylosborne
8 - Asteroid
Spoiler
Harrylosborne_0-1631874115962.png

 

TimN
13 - Pulsar
Spoiler
TimN_0-1632348542004.png

 

pfaigmani
7 - Meteor

My solution to challenge #19

MichelleL
Alteryx
Alteryx

Interesting how different the solutions can be . . .

RS452
7 - Meteor

Good use of Multirow formula.

AndrewSu
Alteryx
Alteryx

my take 🙂