Challenge #200: Sudoku Solver

[avinashsunchu]

Spoiler

[CaminoPinan]

Second challenge done...beginner level! #StepByStep

Spoiler

[Neetu]

My solution for Beginner and Intermediate

Spoiler

Spoiler

[Amin]

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!

Advanced Solution:

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.

[AdrienGohy]

here is my solution

[jackie_liu]

Solved beginner & intermediate.

Spoiler

[PeterH23]

Solution (Beginner)

Spoiler

[PhilipMannering]

I'll come back to the Advanced. Promise.

Spoiler

Advanced solution coming soon..............................................................................

[Jeanettecf]

Beginner level: 

Spoiler

[aruiz-itp]

Here my answer