Channel: MrExcel.com

Category: Howto & Style

Tags: exceladvanced filter in excelmrexcelwordle guessing traceusing unique in excelusing excel for 1 billion calculationswordle theorymicrosoft excelbill jelen

Description: 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. 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. For a great Wordle Analysis from Laurent Lessard: laurentlessard.com/solving-wordle Table of Contents (0:00) Introduction (1:15) Colors in 53 formulas (6:10) Laurent Lessard or 3Blue1Brown (7:25) The 2315 words (8:50) Solving for 5.3 Million with 284 MM formulas in Excel (10:40) The 10,972 words (11:57) 2315 x 12972 x 53 of 1.3 billion (13:00) Wordle Universe 1.596 billion calcs (14:25) Can be the answer? (14:59) Count unique constellations per guess (17:17) It is not 3^5 possible answers (18:10) Show 10 largest using LARGE in Excel (18:30) Using Ctrl+Right Arrow in Excel (18:46) TRACE, CRATE, or SALET starting words (19:38) 10 words with most constellations (20:14) Max words in play after any guess (20:36) COUNTIF for each in array in Excel (21:30) What's the most words still in play (22:20) RAISE or ARISE for less words in play (23:00) Is Wordle a hostile opponent? (23:34) Solving methodology (25:05) Filtering to find 10 words still in play (26:00) Sheet2 for words still in play (26:38) Evaluating the best for 2nd word (28:45) Guessing a wrong word narrows it for the win (29:16) Which words will minimize words in play (30:00) Having 221 after first guess (30:25) Using Excel Advanced Filter from another sheet (32:05) End game strategy wins 2nd guess from now (34:10) Increase chance of less than 100 words after first guess (35:30) Maximize winning in 2 PARSE, CRATE, TRACE (36:50) The worst first guesses in Wordle (37:15) TARES, SANER, AISLE, ALONE as best words (38:40) Over 1000 words in play after first guess (39:10) AISLE ALONE for less than 200 words (39:20) PARSE or CRATE or TRACE