numbers 1:16 are in the cells in column a.

Are the numbers in column A (1 to 16) in sequential order or are they in
random order?

So, you want a 16 x 16 matrix with no duplicates on any row or in any
column?

--
Biff
Microsoft Excel MVP


"jeel" wrote in message
...
I would like to create a table that is 16 rows deep and 16 columns across
where the
numbers 1:16 are in the cells in column a. Then going across I need each
number to appear in each row without the number being repeated in the
column.
Similar to suduko but using 16 spaces. Is there a formula to do that?