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

[alexnajm]

Great challenge @caro_smith!

[TonyAndriani]

One of the best challenges I've seen in quite a while. 

Spoiler

I used CharFromInt() and CharToInt() to avoid having to hard code character codes. Also did this as a general purpose macro just for fun.

[martinding]

Spoiler

[tammybrown_tds]

Interesting use of a new function that I've never seen before.

Spoiler

[Kamran1991]

my solution

[acarter881]

Here's my solution. I believe there is no way to solve for this in a dynamic way without the use of a macro. The example deals with only 100 columns, but solving for any number of columns requires a macro. I'll demonstrate solving it in a programming language as well.

Macro

Spoiler

Workflow

Iterative Macro

Python (done in VS Code for illustrative purposes only)

Spoiler

[ggruccio]

Catching up from being at Inspire!

Spoiler

I couldn't think of a way other than using a manual input for the mapping.

[Jcdf1993]

Spoiler

[Miles_Waller]

Probably not the most elegant solution, but it works!

Spoiler

[Watermark]

More tools than I wanted, but going for quick tonight to catch up after Inspire. 

Spoiler