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

Bobbyt23
12 - Quasar

Well it seemed simple then couldn't work out how to add the letters.

Spoiler
Learnt the CharFromInt([ID]+64) function in this one. Really useful!!
aatalai
14 - Magnetar

C372

Supriya2203
8 - Asteroid

Using

  • Data Transformation
  • ASCII codes i.e. CharFromInt(64)= A
  • Divisor dividend concept for remainder calculations
mkeiffer
10 - Fireball
10 - Fireball

Here is my solution!

Spoiler
Screenshot 2024-08-09 at 12.21.03 PM.png

MelGibson
10 - Fireball
Spoiler
372.png


lwolfie
11 - Bolide

Got it

mgaronson
11 - Bolide
Spoiler
Challenge 372 Workflow Pic.png

 Mod function is key

cmoussa
8 - Asteroid

WF.png