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