Home |
Search |
Today's Posts |
#16
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am only looking for the numbers 1 through 40, not 1 to 1600.
Each row and column should contain no duplicates. numbers should be in random order. "SteveW" wrote: On Wed, 24 Jan 2007 23:19:17 -0000, MyVeryOwnSelf wrote: Is there a way to create a 40 by 40 sheet where each column and each row have no duplicate numbers. And have this randomly generated? Here's one way. In cell A1 of Sheet1, put =RAND() and extend right and down 40 by 40. In cell A1 of Sheet2, put =RANK(Sheet1!A1,Sheet1!A:A) and extend right and down 40 by 40. Hit the F9 key to get a new set of values. There is is a bit in the original question that says *NO DUPLICATES* The question is whether that original poster wants the numbers 1 through 1600 arranged randomly in a 40 x 40 grid or the numbers 1 to 40 arranged in each row such that each column has the numbers 1 to 40 ie if it was 3x3 1 2 3 . . . 1 2 3 4 5 6 . . . 2 3 1 7 8 9 . . . 3 1 2 using the numbers 1 to 9 or 1 to 3 in eachrow/column -- Steve (3) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
random number | Excel Worksheet Functions | |||
Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
same number appears in a random number generator | Excel Worksheet Functions | |||
Random Number Questions | Excel Worksheet Functions |