Thread: table formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jeel jeel is offline
external usenet poster
 
Posts: 33
Default table formula

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?