Challenge #372: A Header Reference Dataset from Excel Header Reference Letters
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
18 - Pollux
05-26-2023
12:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great challenge @caro_smith!
TonyAndriani
9 - Comet
05-26-2023
04:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
13 - Pulsar
05-26-2023
06:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
tammybrown_tds
9 - Comet
05-27-2023
08:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Kamran1991
11 - Bolide
05-28-2023
05:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
acarter881
12 - Quasar
05-28-2023
07:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)
ACE Emeritus
05-30-2023
06:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Catching up from being at Inspire!
Spoiler
I couldn't think of a way other than using a manual input for the mapping.

Jcdf1993
6 - Meteoroid
05-30-2023
10:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Miles_Waller
8 - Asteroid
05-30-2023
02:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
12 - Quasar
05-30-2023
06:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator