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 #372: A Header Reference Dataset from Excel Header Reference Letters

ErikStroem
6 - Meteoroid

Probably not the fastet way to solve it. But it did the job. 

Nice one!

kytes_
5 - Atom

Great!

TurboToad
9 - Comet

My solution.

 

Spoiler
TurboToad_0-1685026778492.png

 

Isabella_Venturini
7 - Meteor
Spoiler
Isabella_Venturini_0-1685098064414.png

 

Isabella_Venturini
7 - Meteor
Spoiler
Isabella_Venturini_0-1685099552531.png

 

JereJussila
8 - Asteroid
Spoiler
JereJussila_1-1685100019097.png

 


 

View my solution !

mg46
8 - Asteroid

 

Spoiler
mguarniere_0-1685120536751.png

 

logdog0411
8 - Asteroid
Spoiler
logdog0411_0-1685127928981.png

 

I had a VERY complicated answer where I used a Text input and a Union to create a data row, then pivoted into column to create the letter string. 

 

Then I checked someone's spoiler and remembered the Field Info tool. I had never used it before. 

 

Now other than the Formulas (Which I showed in the screenshot), it's pretty simple. 

 

This was a creative and different challenge!

logdog0411
8 - Asteroid

Would just like to point out that I was trying to work on this challenge yesterday at the Solutions Center at Inspire, but had soooo many people come to ask questions that I could make no headway. Best distraction ever! 

 

@gptacek 

@TanushreeArora 

@kingrum 

Marc Oliver

@mariam_khalid 

@kev_hinds 

 

(some of these are guesses... thanks for livening up my afternoon!)