LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Needed! Roman Excel Discussion (Misc queries) 2 June 19th 05 09:29 PM
Help on Macro or Formula Nigel Excel Discussion (Misc queries) 2 June 13th 05 01:27 PM
Macro needed to Paste Values and prevent Macro operation thunderfoot Excel Discussion (Misc queries) 1 June 11th 05 12:44 AM
Macro or Formula to remove Text from Cells smck Excel Worksheet Functions 6 May 11th 05 03:22 AM
Help with macro formula and variable Huge project Excel Worksheet Functions 0 December 28th 04 01:27 AM


All times are GMT +1. The time now is 09:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"