Challenge #75: Scrabble Word Finder

[ggruccio]

WOW!  That was a challenge!

[samN]

really, very happy with my solution. One macro to rule them all, with the only input required is how many blanks exist. Runs all three simultaneously in less than a second. 

Spoiler

Probably my favorite challenge yet!

[jasperlch]

I have used the Combination macro in my solution.

[TerryT]

That was so fun!

[JosephSerpis]

Challenge Completed

[shanakag]

Thought to give a try for this challenge. 

[jamielaird]

Here's my solution. I wanted to come up with a macro for this but in the end I went with a more straightforward approach using appends.

Spoiler

[jamielaird]

This is such a clever approach @TerryT! I've never thought of using the same field multiple times in a single formula tool like this. I'll definitely be using this technique in future.

Spoiler

[kat]

Really cool challenge! :) mine can handle duplicates, blanks and runs quickly

Spoiler

[dsmdavid]

Messy, but works. Not fast, but I can wait 3s.

Take the list of letters, process the hand, process words to decide if they can be built with current hand, score those that can and sort. Next time, I should use much more regex...

Spoiler