 So for some reason more people end up watching a Word or Excel video than anything else, okay, fair enough. So I thought I'd follow up with what I've done to it since, because this is starting to get really complicated now. So mostly it all remains the same, the core logic and the game is fine, but I've made a couple of updates and changed it. Mostly I'm now using a lot more named ranges, so if I select SEQ for sequence here, that number 12345 now is sequence. It's a sequence of just five letters. So if I have a look at something here, I've done the mid, the input text and then the sequence. And because I'm now working on 365, it will automatically spill that range to the right. Rather than needing to put it in as an array formula. So this will have really only work on the latest version of Excel. So its compatibility is a bit terrible. I've added in a Brawley, what's that? Subbin button just to change these numbers. That's not that useful, to be honest. But we can also see what else my inputs have given that in named range as well. So all I need to do is, if I want to find out how many guesses someone has, I just need to count a inputs. And that will work everywhere. I know I've had five guesses. Put the correct one in there. Oops, sorry, diver not driver. So what else? I've clearly, if you've seen it, I've done what I said at the end of the previous video. I've put all the code to actually do the yes no down here. That hasn't changed from the previous version. I've just referenced the conditional formatting to here. So instead of an if the cell is equal, I've used the where the formula is true. And copy pasted that everywhere. And updated the numbers to look like the online game. Updated the formatting to look like the online game a little bit. Put it as capital letters using the upper, which is useful. The thing about doing that is that all of these then suddenly broke when I dragged everything down. So it was still referencing up here. So I've had to go through all those references and drag it down to the bottom to update it. Should have done that first time around because this makes a bit more sense. And if you're here for Excel or spreadsheet stuff, this won't be very interesting. But if you do teaching or anything, the fact that these are highlighted reduces kind of the cognitive load on anyone playing the game. I think that's why Wordle has got quite popular. A lot of the keyboard you tap into it with is highlighted. So you know that the letter you're pressing is struck out or confirmed and all the letters at the top here. The previous session I had, you had to make a lot of matching between the word you typed in and just the code, whether it was red, green or yellow, but highlighting it to you kind of takes that load away. So it makes the game a bit faster to play and a bit easier. So you can focus on the actual solving of the problem, not fighting the interface. So I think that's kind of really interesting. So it's kind of worth doing if you build something like this to think about that load that you put onto people. Anyway, what else? I've altered the code in here a little bit because I'm now trying to find, to not repeat letters. Previously I was just chaining the letters together and that was producing long strings and was a bit wasteful. But I'm now making sure if it's particularly struck out here and it can't be found up here at the letter one, if not ignore it. So this in the previous version would have chained on the same letter again, but it doesn't now. And you might think that's a really easy thing to do. You just use an and function to give it two logics. If it's in here, but not in the above cell. No, it's not that easy because ants doesn't work over arrays. It takes while it takes an array and it can calculate it down to just one output where they're all true. So you can't check across here and check up here separately. So it has to be a nested if statement to do that. There's the if here and then the second if. And the one for the other one is actually a, that's just one up here as a monster formula now doing that. If it's yes and then if it can't be found here and then if it's also M. Oh, it's a monster. I can't even remember what that's doing now. And then here I am checking if, you know, kind of the spit of this equals the answer array. So I've named that thing answer array. So this keeps track of all the letters that are in the right place. This keeps track of the letters that are definitely kind of confirmed. This keeps track of all the letters that are definitely not in there. And then we count them up. And what you might notice is there's a counter at the bottom saying 700 words are available. 2000 words available. Let's delete that 5000 to 757. So that's how many words are in my word list on the other page. And then I tried to figure out, can you, can you find out how many words are left on your word list? And this could like, so if you type in tears, it's dropped it down to 13 underpossible words out of nearly 6000. So obviously that's a very efficient starting point. Try that. Oh, there's two and a half thousand words. So that's a less efficient starting point. Okay. It turns out that's easy and also not easy because you have to remember that it's multiple guesses that you have to go over. So you have to find kind of the max number of these. Oh, it's kind of complicated anyway. I'm trying to do three statements. I'm saying, are they in definite positions? Are they confirmed to be somewhere in there? And were they not there at all? And there's, I'm trying to remember the exact, I did this a few days ago and I've completely forgotten how I actually did it. That formula now makes no sense to me, unfortunately. It's kind of the downside of this being Excel code rather than programming where you can leave comments. You can add comments and comment it, but it's not what it's designed to do. And the whole thing is, if all of these are true, keep it true, count the number of truths and that's roughly gets you the number of words left. It's a really weird bit of logic to code in. And it's especially difficult to actually code in logic that says, well, we know there's an R in it, but it's not in that position. That's actually, that's effort I haven't bothered to go through yet. So this is always a slight overestimate. And it might go up and down depending on how the double letter problem works because that might work. So that's where it's up to. We can now start hiding all these. Oh, yeah, over here. I've tried to concatenate together. Let me just put this in there. So if the number of answer inputs is in zero and your answer equals the last answer equals the answer, give a little code just like what the Twitter game does. And if you don't get it, oops, I keep misspelling that one. That's popular, isn't it? There's a starting point I can keep adding this. Oh, no, it's wrong. It concatenates out a slightly different starting point if your answer doesn't match. That's a lot of stuff going on. I had to copy and paste these squares from somewhere. They only appear black and white, but you copy paste them into a text box by just making it reference that. It appears as the colored version, just like the emoji does. So all they'd be left to hide the stuff you don't need. Hide that. You can copy paste that cell somewhere, but there is something about where it adds extra return spaces. Hide that. Hide all of this again. And there we are. It's ready to go again. So we can... Oh, it gives me the answer at the end. So probably the only thing to take this next is I know that the online game, it's possible answers and it's acceptable inputs are two different lists. The acceptable inputs is a bigger list than possible answers. So the possible answers probably wouldn't include words like that, because it's a four letter word with an S on the end. And that's about 30% of this word list of four letter nouns that are plural. So you would want to strike those off your possible answers, but not necessarily your inputs. And that would be another bit of coding to do. So it would reduce this down to maybe, if not nearly 6,000, maybe 2,000 words, 3,000 words as possible, good answers. But you'd want to then expand the number of acceptable inputs that a player can stick in. That would be just basically finding two different word lists is the issue there. That would be fairly easy to swap around. You just have to do your validation in a different way, because this is the one that does the validating here. I'd have to check whether it's not a word or not in the different word list. That would be it. So that's where it's now getting really complicated behind the scenes, but it does a lot more stuff now.