Well, it started as a 2 hour project. That escalated quickly and it took about a day to build Wordle Solver using Excel:
While putting together a decent dictionary, cleaning it up and filtering for 5 letter words was straightforward, enhancing the logic as edge cases came by took some effort.
You can download and try it out here.
Tweet @vamsi_yuvaraj or email me if you find any issues.
PS
Excel still doesn't work reliably in case there are letter repetitions in your initial guesses. Try avoiding them if possible.
One macro (to remove repeated letters from a cell) was used. If you have a way to do it using excel formulae, do reach out. Will credit it!
I intentionally left the sheets and cells unprotected. Feel free to tamper and play with it if you understand my unkempt logic that is!