The challenge this week is as follows (you can download the workbook here):
It is you to start in a game of Scrabble, and your rack of letters (cell Q2) is DGTAROZ.
You are a strong enough player to have deduced a list of all possible words from the Engligh language of two or more letters which can be formed from this rack. Given that list in Q5:Q77, derive a single formula to return the word from that list which returns the highest score when placed on the board (A5:O15).
The chosen word may be placed anywhere on the board, either horizontally (reading left-to-right) or vertically (reading top-to-bottom), though not diagonally, on condition that the central square (◊) is covered.
The score for a given word is obtained via looking up the individual value – using the table supplied (U3:V28) – for each of the letters within that word and totalling those values.
If the chosen word covers any of the squares marked “2W” then the score for that word is doubled. (Readers familiar with the game of Scrabble will notice that I have taken the liberty of replacing double-letter tiles with double-word ones for the sake of simplification. It might also be pointed out that the usual doubling of score for words passing through the central square is here a moot point.)
If more than one word share the highest possible score, then any one of those words may be returned.
Note that this is a shortest formula challenge, which means that readers should attempt to find not only a correct solution to the problem but also one which has the least number of characters as possible.
Any ranges must include both a row and column reference: A:O or 5:77, for example, are not acceptable. Named Ranges are also not permitted.
Solution next week. Best of luck!