Free Trial

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

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
Not beutiful...

AkimasaKajitani_0-1684781785044.png

 

rachel_lynch
Alteryx
Alteryx
Spoiler
rachel_lynch_0-1684785181539.png

 

Rachel Lynch
Clifford_Coon
11 - Bolide

My Solution: 

Spoiler
challenge_372.jpg


Formula:
if (ceil([RecordID]/26) - 1) = 0
THEN ""
ELSE charfromint((ceil([RecordID]/26) - 1) + 64)
ENDIF
+
if mod([RecordID],26) !=0
THEN charfromint(mod([RecordID],26) + 64)
ELSE charfromint(90)
ENDIF

Flo_P
9 - Comet
Spoiler
Flo_P_0-1684787170212.png

 

annbriceAB
8 - Asteroid

A fun challenge! Thanks!

ARussell34
8 - Asteroid

I took a bit of a round about way, but found the solution!

 

ARussell34_0-1684792687202.png

 

AaronSmatta
8 - Asteroid

Solution

François_Rs
8 - Asteroid
Spoiler
Franois_Rs_0-1684826692173.png

 

Christina_H
14 - Magnetar

My solution

Spoiler
Christina_H_0-1684832130716.png

 

olga_strubbe
11 - Bolide
Spoiler

olga_strubbe_1-1684844994845.png

 

A neat challenge, thank you, @caro_smith !