Final Friday Fix: November 2022 Challenge
25 November 2022
On the final Friday of each month, we are going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you are playing for bragging rights only!
This month, we are playing an Excel word game in which a set of letters is provided, and players need to unscramble it to make words that have meanings. Our job as a host is to check whether the words are correctly generated from those letters.
It is easy to check whether a word is meaningful in Excel as we can simply use the Spelling button under the Review tab or press F7.
In this challenge, the objective is to check whether a word is made from the provided letters. You can download the question file here.
Your solution should look like the Check column in the picture below.
As always, there are some rules:
- this is a formula challenge; no Power Query / Get & Transform or VBA!
- no helper cell(s) is / are allowed
- the formula should not be case sensitive
- the length of words produced by players may vary.
Sounds easy? Then why not have a go? We’ll publish one solution in Monday’s blog. Have a great weekend in the meantime!