Excel Magic Trick

[@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!

[@excelisfun]

Awesome solution!

[@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...

[@larasservicesfl]

THANK YOU VERY MUCH FOR YOUR SUDOKU PUZZLE. I'm currently trying to build a schedule for staff at the workplace. I needed a way to sort and adjust list for backups without repeating. I believe your puzzle formulas will help. I will try and build it.

[@excelisfun]

Dear SHIRAIKOTAROU177, No pro here! Just an guy having fun with Excel! --excelisfun

[@mohammadasjad7221]

I wish to create a sheet in which sudoku puzzle is created. For example if I enter 1 in A1 then a sudoku puzzle is created in range A2:I10. Can you help with that?

[@aungshwe4939]

It is giving me #value error for =IF(OR(A$1:A$3=D6,B$1:B$3=D6,C$1:C$3=D6),D6,"") . Can you please give me suggestion?

[@excelisfun]

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

[@aselamaryvosarogo3671]

how do you download this template?

[@davidgooley8940]

ExcelIsFun I tried to do this, but in the Numbers Used column, it kept giving me #VALUE! and would only search for the number 1.

[@akashmalya984]

same here

[@plagoeoeri]

@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.

[@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))

[@plagoeoeri]

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))