We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
alteryx Community

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

## Challenge #200: Sudoku Solver

8 - Asteroid
Spoiler

8 - Asteroid

Second challenge done...beginner level! #StepByStep

Spoiler

8 - Asteroid

My solution for Beginner and Intermediate

Spoiler
Spoiler
8 - Asteroid

Have always been inspired and jealous of my Prime Minister, who designed his own sudoku solver back in May 2016!

Since then I've always wanted my own design to solving one of my favourite pastimes i.e. Sudoku..

Spoiler

That’s why the wefie with him! Haha!

Spoiler
This is for Rows. Rinse and repeat for Columns and Blocks

Logic I used:

If the length of a value is the same as the occurrence of the value in a given set, then the rest of the cells in the same set must not be able to contain that value anymore.

First Example:

if there is only one occurrence of 8 in a row, then the rest of the cells in the row must not be able to have an 8.

Set considered = Rows
Value = 8,
Value Length = 1,
Occurrence = 1,

Second Example:
if there are only two occurrence of 37 (3 and 7 as remaining options in a cell) in a column, then the rest of the cells in the column must not be able to have a 3 or a 7.

Value = 37,
Value Length = 2
Occurrence = 2,
Set considered = Column

Same logic applies for the other sets, ie. Rows(9x1), Columns(1x9) & Blocks(3x3)

Please advise on how I can refine this solution (manually repeated currently), I'd really like to use a reiterative macro to improve this but yet to find a resource that is able to help me use it.

8 - Asteroid

here is my solution

8 - Asteroid

Solved beginner & intermediate.

Spoiler
8 - Asteroid

Solution (Beginner)

Spoiler
14 - Magnetar

I'll come back to the Advanced. Promise.

Spoiler