Challenge #372: A Header Reference Dataset from Excel Header Reference Letters

[Bobbyt23]

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]

C372

[Supriya2203]

Using

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

[mkeiffer]

Here is my solution!

Spoiler

 

[MelGibson]

Spoiler

 

 

[lwolfie]

Got it

[mgaronson]

Spoiler

 Mod function is key

[cmoussa]

[JBevan89]

Solution Attached.  Great Challenge.

I did a bit of reading on Google, and it seems that the char numbers differ between softwares, as for example the numbering is different in Python

[3I_ATLAS]

Slightly tricky... Think I took a similar approach to  @dsandmann.

Good use case of the FieldInfo tool.

Spoiler