Sudoku checker

[rokkusar]

Hello,
So i have to make a code that checks if the sudoku written in excel is correct.
I would really appriciate your help

 

[eastrand]

Are you wanting something to just check the values of each row and column? Something like this? I added some conditional formatting just to make it stand out. If you want something that will actually solve it, check this link out. Sudoku Solver in Excel

Book3
	A	B	C	D	E	F	G	H	I	J	K	L
1
2		8	3	1	6	7	9	5	2	8		BAD
3		9	6	7	2	5	8	3	4	1		OK
4		5	8	2	1	4	3	9	6	7		OK
5		6	5	9	8	1	7	2	3	4		OK
6		3	2	8	5	6	4	1	7	9		OK
7		7	1	4	9	3	2	8	5	6		OK
8		8	7	3	4	2	1	6	9	5		OK
9		1	4	5	3	9	6	7	8	2		OK
10		2	9	6	7	8	5	4	1	3		OK
11
12		BAD	OK	OK	OK	OK	OK	OK	OK	OK
Sheet1

Cell Formulas
Range	Formula
L2:L10	L2	=IF(SUM(B2:J2)=45,"OK", "BAD")
B12:J12	B12	=IF(SUM(B2:B10)=45,"OK", "BAD")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B12:J12,L2:L10	Cell Value	="BAD"	text	NO
B12:J12,L2:L10	Cell Value	="OK"	text	NO

 

[CasparTyler]

If you’re trying to check a Sudoku puzzle in Excel, you could create a simple code to make sure each row, column, and 3x3 grid has the right numbers.

 

[felixstraube]

Here is a formula that checks if a sudoku is correctly solved:
Would this work for you?

Book2.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2		3	8	7	4	9	1	6	2	5		TRUE
3		2	4	1	5	6	8	3	7	9
4		5	6	9	3	2	7	4	1	8
5		7	5	8	6	1	9	2	3	4
6		1	2	3	7	8	4	5	9	6
7		4	9	6	2	5	3	1	8	7
8		9	3	4	1	7	6	8	5	2
9		6	7	5	8	3	2	9	4	1
10		8	1	2	9	4	5	7	6	3
11
Sheet2

Cell Formulas
Range	Formula
L2	L2	=LET( a, {1;2;3;4;5;6;7;8;9}, osv, {0,0,0,0,0,0,0,0,0,0,1,2,3,4,5,6,7,8,0,3,6,0,3,6,0,3,6;0,1,2,3,4,5,6,7,8,0,0,0,0,0,0,0,0,0,0,0,0,3,3,3,6,6,6;9,9,9,9,9,9,9,9,9,1,1,1,1,1,1,1,1,1,3,3,3,3,3,3,3,3,3;1,1,1,1,1,1,1,1,1,9,9,9,9,9,9,9,9,9,3,3,3,3,3,3,3,3,3}, SUM(BYCOL(osv, LAMBDA(x, (SUM((SORT(TOCOL(OFFSET($B$2, INDEX(x, 1, 1), INDEX(x, 2, 1), INDEX(x, 3, 1), INDEX(x, 4,1))))=a)*1)=9)*1 )))=27 )