Excel Magic Trick #242: Excel Sudoku Puzzle

Excel Magic Trick #242: Excel Sudoku Puzzle

Adresses courriel de vos ami(e)s...
Envoyer cette vidéo par: Prise1 Hotmail Gmail Outlook ou Thunderbird...

Envoyée le lundi 02 février 2009 19:26:05
par ExcelIsFun
Vue 7252 fois

4.3 / 5
18 vote(s)

See how to create a Sudoku Puzzle using array formulas, INDEX function with criteria and data validation.

facebook

Écrire votre commentaire ici...

plagoeoeri

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.
vendredi 17 juin 2011 11:50:14
plagoeoeri

@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))
jeudi 16 juin 2011 17:02:51
ExcelIsFun

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...
samedi 26 mars 2011 16:51:48
ExcelIsFun

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!
samedi 26 mars 2011 11:25:04
Markblackburn86

8 more blocks of those 9 cells and then some duplicate conditional formatting and the game is ready, bar the starting cells. Awesome, thanks again.
mercredi 10 novembre 2010 04:22:56
SHIRAIKOTAROU177

wow u sound so pro
vendredi 06 mars 2009 20:33:25
SHIRAIKOTAROU177

boring
vendredi 06 mars 2009 15:58:42