![excel solver function also known as excel solver function also known as](https://www.excel-easy.com/data-analysis/images/solver/solver-results.png)
If it's snowing where you're at, and you hate the Super Bowl, and you need a video to put you to sleep, this is it.įor all of my regular viewers who are looking for something cool in four or five minutes, I'm not offended. There's people who are doing this much better than I am, and I'll send you links to those. I never know what Excel video is going to take off, right?Īnd that Wordle video where I chose AROSE has now have people calling me a CNN-cited Wordle expert, which is just insane. You probably don't know, when you get an email from Larry Robinson, it can turn into an obsession.Īnd just for any of you who are still playing AROSE as your first Wordle word, there's better words, TRACE.īut there's other better words depending on your strategy. You already know this: the new dynamic array formulas are wildly helpful. I geek out, because I can run one and a half billion calculations in Excel without crashing. This is an insanely long video, and let me just save you some time. Holy smokes, 1.5 billion calculations in Excel. (39:10) AISLE ALONE for less than 200 words (38:40) Over 1000 words in play after first guess (37:15) TARES, SANER, AISLE, ALONE as best words (36:50) The worst first guesses in Wordle
![excel solver function also known as excel solver function also known as](https://cdn.wallstreetmojo.com/wp-content/uploads/2019/10/Linear-Programming-in-Excel.png)
(35:30) Maximize winning in 2 PARSE, CRATE, TRACE (34:10) Increase chance of less than 100 words after first guess
![excel solver function also known as excel solver function also known as](https://i.ytimg.com/vi/STY9ZQ5BhDk/maxresdefault.jpg)
(32:05) End game strategy wins 2nd guess from now (30:25) Using Excel Advanced Filter from another sheet (29:16) Which words will minimize words in play (28:45) Guessing a wrong word narrows it for the win (25:05) Filtering to find 10 words still in play (22:20) RAISE or ARISE for less words in play (21:30) What's the most words still in play (20:36) COUNTIF for each in array in Excel (20:14) Max words in play after any guess (19:38) 10 words with most constellations (18:46) TRACE, CRATE, or SALET starting words (18:10) Show 10 largest using LARGE in Excel (14:59) Count unique constellations per guess (13:00) Wordle Universe 1.596 billion calcs (8:50) Solving for 5.3 Million with 284 MM formulas in Excel This is a long video for the weekend, mostly of me geeking out about Excel and doing 1.5 billion calculations with a $10 spreadsheet.įor a great Wordle Analysis from Laurent Lessard: Solving Wordle - Laurent Lessard After my previous video showing AROSE as the best first guess in Wordle, I started doing some more cool Excel formulas to test all Wordle words.