Channel: MrExcel.com

Category: Howto & Style

Tags: excelwordle best starting wordusing xlookup for each letter in a word in excelmrexcelwordle strategywordle tipsmicrosoft excelbill jelenusing excel to help with wordleis adieu a good starting word in wordleusing mid of an array in excelusing find to find several letters in excel

Description: Everyone has their theories on the best starting word for the Wordle game. A lot of people suggest ADIEU. But when you look at the frequency of each letter in the 8000 possible words, a better start word has AROSE. This video starts out with the most popular words. After that video wraps, a deep dive into the Dynamic Array Formulas that made all of this possible. Table of Contents (0:00) What's the best Wordle Starting Word? (0:48) Statistical analysis of most common letters (1:20) A few alternate best starting words (2:11) Scoring ADIEU and other common starting words (2:49) Learn Excel on Retrieve (3:10) Organist Nancy Faust plays (3:21) Using UNIQUE with By_Col set to True (3:50) VSTACK from Charles Williams (3:55) Getting rid of 0 from empty cells using FILTER (4:23) FIND to find an array of letters (5:29) XLOOKUP of each letter in a word.