Thread: soduko
View Single Post
  #8   Report Post  
Leo Heuser
 
Posts: n/a
Default


"webby62" skrev i en
meddelelse ...

Is there a way of checking the whole nine boxes individually so that
there are no two numbers the same in each box? i have done the rows
and columns with countif but need each separate box to show if they
are doubled thanks


--
webby62



Webby

Assuming Sudoku square in A1:i9, enter this formula in e.g. K1:

=IF(ISERROR(MODE(OFFSET($A$1:$C$3,(ROWS($K$1:K1)-1)*3,
(COLUMNS($K$1:K1)-1)*3))),"No dups","Dups")

Copy K1 to K1:M3

K1 will check for duplicates in the square A1:C3, L1 for duplicates in
D1:F3,
K2 for duplicates in A4:C6 etc.

Nice game Sudoku :-)

--
Best Regards
Leo Heuser

Followup to newsgroup only please.