Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 ![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Needed! | Excel Discussion (Misc queries) | |||
Help on Macro or Formula | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro or Formula to remove Text from Cells | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |