Creating Wordle in Excel

Excel was definitely not designed to make games in it... but it is possible to make games in it. It's actually not terribly difficult, it was about an hour or so of messing around. So, this video looks at how to recreate the Wordle game -- a Mastermind-like game, where you guess a 5 letter word and it responds by telling you what you got right, and what you got nearly right. It's rough, obviously, but it's functional, and a good exercise in thinking about breaking problems down into small solutions, and assembling them into something bigger.
The file can be downloaded here: hullacuk-my.sh...
If anyone asks, I did not say it was okay to use Excel like this for serious work. Actually, that's a lie. If you're going to use Excel for serious work, this is how you do it. Break problems up and reuse functions. Test it using inputs you know the answer to. Basically, it's coding/programming, isn't it? Even if you are using it for what it was actually designed to do, treat it as code first.

[@ev-yt2064]

Thanks for the download. It works really well.

[@puellanivis]

Love seeing just how far Excel can be stretched.

[@bernardthomson9777]

I much appreciated your efforts. Being curious yet no expert, is it too much to ask that you share the excel file?

[@ChrisArmstrongChemistry]

I've added it to the video description.
After the last round of changes, it will only work in 365/online.

[@jgeekw]

Can you share this file again?

[@Seacowdaz]

Hi The link for the download has expired is there anyway to get a copy of the file?

[@slaxhz6183]

Thanks very helpful

[@petercarl832]

Thanks Chris. One thing though, if the solution is say MAXIM and I guess MIMIC, then it is telling me there are two Is in the solution - one yes and one maybe.

[@ChrisArmstrongChemistry]

I never did get around to coding the double-letter rule(s) properly.

[@petercarl832]

@@ChrisArmstrongChemistry Thanks for the update. I managed to do it in a fairly agricultural way using many columns!

[@adamhawkins6579]

Thanks for posting the video, it is very good and I enjoyed playing around with Excel to get a version working.
Are you able to share or direct me to where you got your word list please? As you say in the video the 12,000+word lists are not practical to use to play and one's around 2,500 that I have found use American English spellings. Any direction would be appreciated. Thanks.

[@ChrisArmstrongChemistry]

Found it again! (The fact it's hosted by Donald Knuth and I'm using a Microsoft product is possibly ironic...)
www-cs-faculty.stanford.edu/~knuth/sgb-words.txt

[@adamhawkins6579]

@@ChrisArmstrongChemistry Thank you