Wordle with Excel Solver

Super Contributor

Amid the plenty of solutions and techniques that are coming for the newly viral word-puzzle game Wordle. I have also tried to make an excel-based solution for the puzzle. Because, being an excel enthusiast, I believe that Excel provides more flexibility and customization power than other analytical and problem-solving tools.

 

The primary aim of sharing the solution with the respected members of this excellent community is to have different logic and alternative solving approaches that would surely provide some learning opportunities. The element of interest for the members is to model an approach that would produce more close and accurate guesses.

 

For this solver, I have got inspiration from Mr. Robert Gascon, who occasionally demonstrates excellent features of traditional excel. Therefore the solver is a non-VBA / non-CSE model and does not require the 365 version of Excel. Thoughtful comments, especially from Mr. Robert Gascon @Twifoo  and Mr. Sergei Baklan @Sergei Baklan about alternate solving approaches will be valuable.

 

The solution of two real games along with the solution strategy is also attached for reference purposes.

 

Thanks

Tauqeer

2 Replies

@tauqeeracma you sir are a genius! I think many people will find this helpful for the highly popular game, Wordle.

Thanks for your comments.