PDA

View Full Version : generate numbers without reversing the dozen on the same line



marreco
12-04-2012, 04:54 PM
Hi.
I need to create random numbers with 10 columns and 10 rows.


But for each line can not be the number opposite each decade.
79 22 48 70 04 98 09 41 32 56
59 17 42 67 5 67 94 47 46 21
85 66 70 90 89 83 84 50 81 36
83 50 36 3 57 55 20 39 51 77
23 67 39 29 12 86 68 18 87 73
90 3 54 26 72 17 69 13 44 36
10 11 37 98 84 19 63 54 22 59
65 26 3 55 68 61 9 76 75 69
33 28 38 59 87 74 63 60 41 90
94 50 01 29 59 8 33 47 87 91
see the first line was generated as the number 79, then this same line, can not generate the number 97.


number 22 in this case is OK.


The first line was generated the number 84, then this is not the same line, you can generate the number 48.


The first line was generated the number 07, then this is not the same line, you can generate the number 70.


and so
97 22 84 07 40 98 90 14 23 65
Cross-Post
generate numbers without reversing the dozen on the same line (http://www.mrexcel.com/forum/excel-questions/671978-generate-numbers-without-reversing-dozen-same-line.html)

Admin
12-04-2012, 05:33 PM
Hi

So what's the logic not to have 97 against 79, whereas can have 48 against 84 ?

marreco
12-04-2012, 06:09 PM
Hi.

if on the same line, can not have.

the same line I have, 97 I can not have 79, the same line I'm 48 I can not have 84