View Single Post
  #1   Report Post  
Query
 
Posts: n/a
Default Formula or Macro needed?


Hi, I need some help desperately, for reasons which are too complicated
to go into right here and now, I need a formula or a macro to produce
an excel spreadsheet of 16 columns and 16 rows where each row and each
column contains the numbers 1 through to 16 without the same number
repeated on any row or any column - I know it may sound a little tricky
but I'm hoping somebody is up for a challenge like this and
can help rather quickly - I'm not interested in the number of
permutations or anything daft like that - I just need a solution.

Thanks to anybody who knows and can post how to help me out of this
trickly situation..


--
Query
------------------------------------------------------------------------
Query's Profile: http://www.excelforum.com/member.php...o&userid=28013
View this thread: http://www.excelforum.com/showthread...hreadid=475189