@Markblackburn86
No, it is not that easy!
The solution here refers only to a 'small' square, e.g. 9 Cells = 1 Dropdown
In essence for a 'real' working solution you would need 81 ! Dropdowns, namely 1 for each of the 81 Cells of the 'big' square. This is because you have to eliminate numbers also if the are already used in their row and column of the big square. Working that out will be a real challenge.
@ExcellsFun
Sorry for the typo (copy/paste) from a german Excel for the named-range formula.
In english XL it should read:
=OFFSET($F$6,COUNTIF($F$6:$F$14,0),,9-COUNTIF($F$6:$F$14,0))
This problem is far to complicated solved!!!
You need 2 simple formulas (non-matrix)
E6 and down =(COUNTIF($A$1:$C$3;D6)=0)*D6
F6 and down =SMALL($E$6:$E$14,D6)
and for the NAME numbers_left (drop-down-list)
=OFFSET($F$6;COUNTIF($F$6:$F$14;0);;9-COUNTIF($F$6:$F$14;0))
Perfect Squares - I just changed row and column height
Q1: Perfect Squares - I just changed row and column height.
Q2: I do not understand your question - can you restate it? If you are asking how to split a cell, there is no direct way to do it (like there is in a Word Table) and the indirect way is a hassle.
BTW, I have no idea how to play Sudoku, I just took this exercise as a logic challenge...
@ExcelIsFun how did you make perfect squares i tried with exel 2007 but i cant figure it out cause it looks like you could make a shortcut by just putting the numbers in the boxes but that brings me to another question how would you make the bigger lines that divide the smaller groups of the puzzle like the 3 by 3 sections in a 9 by 9 box
You are right. I have been teaching Excel for many years and the Mixed Cell References almost always make Smart people Crazy. :) If I did not know Excl I would use the online one too!
Dear SHIRAIKOTAROU177,
For a 13 year old, I am sure it is! Later, you will see that life is like a boomerang and whatever you throw out comes back to you!
--excelisfun
Français
