G
Garry
This solving of this gem of a number puzzle is a just a
bit of fun but is something that my colleagues and I try
to complete every day from a National newspaper. The
premise is simple, you are presented with a grid (9x9
cells) that is made up of 9 sub grids (3x3 cells). The
idea is to complete the grid so that each sub grid
contains the numbers 1-9; each row (9 rows) must also
contain the nos 1-9) and each column (cols) must also
contain the nos 1-9. The paper provides cleverly placed
numbers to help you get started. More often than not the
puzzle beats us during our lunch hour. We have been
trying to solve this using Excel but to be honest we don't
know where to start. Can anyone provide us with
pointers/solutions as to where we would would start, if
possible, so as to stop us scratching our heads sore every
day.
Here is a sample puzzle. Good luck and have fun...
Garry
Col1 Col2 Col3 Col4 Col5 Col6
Col7 Col8 Col9
Row1 2 8 1 7
4
Row2 7 3 1
Row3 9 2 8
5
Row4 9 4
8 7
Row5 4 2 8
3
Row6 1 6 3 2
Row7 3 2 7
6
Row8 5 6
8
Row9 7 6 5 1
9
bit of fun but is something that my colleagues and I try
to complete every day from a National newspaper. The
premise is simple, you are presented with a grid (9x9
cells) that is made up of 9 sub grids (3x3 cells). The
idea is to complete the grid so that each sub grid
contains the numbers 1-9; each row (9 rows) must also
contain the nos 1-9) and each column (cols) must also
contain the nos 1-9. The paper provides cleverly placed
numbers to help you get started. More often than not the
puzzle beats us during our lunch hour. We have been
trying to solve this using Excel but to be honest we don't
know where to start. Can anyone provide us with
pointers/solutions as to where we would would start, if
possible, so as to stop us scratching our heads sore every
day.
Here is a sample puzzle. Good luck and have fun...
Garry
Col1 Col2 Col3 Col4 Col5 Col6
Col7 Col8 Col9
Row1 2 8 1 7
4
Row2 7 3 1
Row3 9 2 8
5
Row4 9 4
8 7
Row5 4 2 8
3
Row6 1 6 3 2
Row7 3 2 7
6
Row8 5 6
8
Row9 7 6 5 1
9