Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Hi How about this: First column enter 1,2,3...etc up to 16, first row enter 1,16,15,14...etc up to 2, then in the second row of the second column enter a formula that refers to the first cell in your grid then drag across and down. Hope this helps! JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=475189 |
#3
|
|||
|
|||
Thanks for your reply, you mention "then in the second row of the second column enter a formula that refers to the first cell in your grid" - what is the formula that I should enter? -- Query ------------------------------------------------------------------------ Query's Profile: http://www.excelforum.com/member.php...o&userid=28013 View this thread: http://www.excelforum.com/showthread...hreadid=475189 |
#4
|
|||
|
|||
Hi If the first cell in your grid is A1 then =A1 HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=475189 |
#5
|
|||
|
|||
Hi, Update....if you want a totally random look to your grid then try the following once you have your grid set up the way I mentioned before. Copy and paste over the grid using the "paste special" option and selecting "values", this will get rid of the formula and leave you with numbers only. Now insert random numbers directly to the left or right of the grid by using the =RAND() formula and then draging down, then select and sort your grid using the random numbers. You can do the same with your columns by using the same formula directly above or below the grid and sorting from left to right instead of up and down. Hope this helps! JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=475189 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |