Here are the results to the Excel Word Challenge I posted a couple of weeks ago. The Winner is:
Shan Fenderson with CERAMBYCIDAES at thirteen letters
When the MVPs were devising this game, I bet that we would get one 10-letter word and that would be it. But Shan proved me wrong. In order to be crowned King of Excel Word Challenge, Shan has to use the word in everyday conversation today. Good luck with that.
Andy Pope wins the second part of the contest by submitting these functions to test whether a word can be made from Excel column letters. He wins by default since no one else submitted any code. But that shouldn’t detract from his wonderful functions. Very smart using recursion, I hadn’t even thought of that. Here’s what I came up with for a function.
Honarable mention goes to John Walkenbach for A-E-G-I-L-O-P-S. Only eight letters, but all single letter columns. The longest word I could find that only uses single letter columns was six characters. There were about a dozen of them including CHIMPS, CHINOS, BIJOUX, and GHOSTY.
Below is a list of words over 10 letters that I got from an online dictionary.
And here’s some words that were submitted that I like, but which weren’t long enough to win
|Salamanca||(submitted by onedaywhen)|
Congratulations Shan, Andy and John.