Weekly Challenge

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

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

Submit Feedback
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.

Challenge #200: Sudoku Solver

Highlighted
8 - Asteroid
Spoiler
avinashsunchu_0-1581579392375.png

 

Highlighted
7 - Meteor

Second challenge done...beginner level! #StepByStep

Spoiler
CaminoPinan_0-1581686326892.png

 

Highlighted
8 - Asteroid

My solution for Beginner and Intermediate

 

Spoiler
beginner_solution.png
Spoiler
intermediate_solution.png
Highlighted
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!

88FD2CFA-A1CE-4F2C-AD9F-8742897666C1.JPG

Advanced Solution:

Spoiler
This is for Rows. Rinse and repeat for Columns and Blocks
Sudoku Solver.PNG

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.

Highlighted
8 - Asteroid

here is my solution

Highlighted
8 - Asteroid

Solved beginner & intermediate.

 

Spoiler
Challenge_200_Solution_JL_image.JPG
Highlighted
8 - Asteroid

Solution (Beginner)

Spoiler
Challenge#200_Beginner.png
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

I'll come back to the Advanced. Promise.

 

Spoiler
Advanced solution coming soon..............................................................................
Highlighted
7 - Meteor

Beginner level: 

 

Spoiler
Capture.PNG
Highlighted
Alteryx Certified Partner

Here my answer