Split data

[jan]

Hello, I have a list of pairs, eg 01,23 or 24,37 ... I will not put on the forum is great because of 174 pairs, I wanted to divide by 10 to 15 columns, example 01,23 35,36 , 24,35 .... 10 to 15 columns side by side You can see please! My excel 2010, seven

[Admin]

Hi jan,

Welcome to ExcelFox !!

The question is not clear (at least to me). Can you attach a sample workbook with expected results.

[jan]

Hello Rick, is split into 10 or 15 lists of 174 columns, only this> Thanks

[Excel Fox]

jan, your question needs to be rephrased so that the developers understand what you are trying to achieve.

[jan]

Hello, i have a column of 174 rows by 15 columns I want to share only that I want to have on your desktop screen viewing of 15 columns, only this Rick, is how to divide a straight and 15 parts!! only of the word to break into 3 parts, I need only 15 shares this!

[Rick Rothstein]

Hello, i have a column of 174 rows by 15 columns I want to share only that I want to have on your desktop screen viewing of 15 columns, only this Rick, is how to divide a straight and 15 parts!! only of the word to break into 3 parts, I need only 15 shares this!
You keep referring to "Rick" in your messages... I am Rick and this is the first time I am responding to your message. Admin and Excel Fox (the two previous respondents) are different people and neither of those people is me.

Okay, unfortunately I have to repeat what Admin and Excel Fox have told you... your message so far are not clear enough for us to figure out what you want. I know this must be frustrating for you, but you have to keep one thing in mind when you post questions to a forum such as this one... while you can see your data and you know exactly what you want to do with it, none of us here can see your data, nor do we know what you want to do with it, unless you tell us in full detail what your data looks like and what you want to do with it. So far, you have not done that. Admin's suggestion was the best... attach a copy of your workbook to your message and in that workbook show us your data as it exists and, on another sheet, how it should look after being processed. If you cannot attach your workbook (for security reasons perhaps), then at least show us, say, 3 lines of existing data and then show us what you want that data to look like after being processed.

[jan]

Been trying to think of a way to get random numbers 1 to 98 generated without repeating in the same column, however also getting it to perform the same opertaion in 25 or 30 more columns (B:J) without the same number appearing in the same row.

example

1 2 5 4
2 5 3 1
3 4 1 5
4 1 2 3
5 3 4 2

Unsure if this is possible, have created a basic script for random number generation but have no clue how to expand across columns.

[Haseeb A]

Hello Jan,

Try this. Assuming numbers range is B2:B99

In B2,

=INT(RAND()*98+1)

In B3, with CTRL+SHIFT+ENTER, rather than just ENTER

=SMALL(IF(ISNA(MATCH(ROW(B$2:B$99)-ROW(B$2)+1,B$2:B2,0)),ROW(B$2:B$99)-ROW(B$2)+1),INT(RAND()*(98-ROWS(B$3:B3)))+1)

Then copy B3 & paste until B99. After Copy B2:B99 & paste to other columns.

This may slow down the calculation speed, especially if you have used in multiple rows & columns.

Hope this helps,
Haseeb

[jan]

Hello, HASEEB, good work, can turn into a spreadsheet excel 2010?, Please I low as ready file

[jan]

There's something wrong with this formula ... I did not find where ... But it does not work ... have to generate 25 to 30 columns ok

[Haseeb A]

See the attached. Column M:U/Y:AG is just used to make sure number are not repeating/missing. Press F9 key to generate the random numbers.

Copy column J & paste across as needed.

[jan]

Hello HASEEB fantastic, good job, perfect, thank you

[jan]

hello, it's pretty easy to have two groups of 45 numbers each, these groups are formed Groups ranging from 01 to 98 For couples or capicuas reversed, eg 01.10 or 32.23 etc. .. A group is 01.23, 48, 59, 85 ... In the other group has = 10 32 84 59 58 ... Group and one group of two inverted. HASSEB, the macro will select 20 numbers in each group, and form lines of 40 numbers But beware! can not generated line numbers 40 have a couple example 32.23 Or have 23 or 32, numca the two together and so ok with 45 other couples or inverted capicuas Then 01-98 have 45 possible matches, which are the two groups, Can generate some 1200 lines or more Example = 01 03 05, ........ 12.45 Figures 40 until This example = 01,10,23,32 ..... can not delete can not have both numbers or 01 or 10 this example may not appear, ok Then take 20 macro numbers of each group of forty gerndo lines without the inverted bed, or having or having one another along the two numca please send an already planilia activity with command button here are two groups
01 02 03 04 05 06 07 08 09 10 20 30 40 50 60 70 08 90
12 13 14 15 16 17 18 19 23 21 31 41 15 61 71 81 91 32
24 25 26 27 28 29 34 35 36 42 52 62 72 82 92 43 53 63
37 38 39 45 46 47 48 49 56 73 83 93 54 64 74 84 94 65
57 58 59 67 68 69 78 79 89 75 85 95 76 86 96 87 97 98

[jan]

01 02 03 04 05 06 07 08 09
12 13 14 15 16 17 18 19 23 grup 01
24 25 26 27 28 29 34 35 36
37 38 39 45 46 47 48 49 56
57 58 59 67 68 69 78 79 89

10 20 30 40 50 60 70 80 90
21 31 32 41 42 43 51 52 53 grup 02
54 61 62 63 64 65 71 72 73
74 75 81 82 83 84 85 86 76
87 91 92 93 94 95 96 97 98

[jan]

Hello, the row of 40 numbers must have the following criteria = Have a maximum of 20 pairs = 20 and odd Choosing a maximum of three pre three column line and each of the two groups

[jan]

Hello, Rick, here and generate rows of 20 numbers, 5 numbers each frame But not to repeat the positions, = Sample a part five numbers 01,12,21,32,41, can not occupy The positions represented by the same letter Example if the number 01 is the letter A is not three other tables can not be the letter A That is the same position. And so with others, are rows of 20 numbers, the positions are not repeated
A B C D E A B C D E
F G H I J F G H I J
K L M N O K L M N O
P Q R S T P Q R S T
U V X Y Z U V X Y Z
A B C D E A B C D E
F G H I J F G H I J
K L M N O K L M N O
P Q R S T P Q R S T
U V X Y Z U V X Y Z

1 2 3 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 26 27 28 29 30
31 32 33 34 35 36 37 38 39 40
41 42 43 44 45 46 47 48 49 50
51 52 53 54 55 56 57 58 59 60
61 62 63 64 65 66 67 68 69 70
71 72 73 74 75 76 77 78 79 80
81 82 83 84 85 86 87 88 89 90
91 92 93 94 95 96 97 98 99 0

[jan]

Hello, this is easy to separate the last digit and add so example 1st 2nd 3rd 4th 5th 6th 12 15 24 32 42 56 last digit = 2,5,4,2 2.6 Summing the 1st position with the 2nd = 25 Sum a3 th position with 3rd = 42 Add up the 5th and 6th = 26 Up to the demonstration in columns alongside, and paste option Make a planilia and activate. I have excel 2010, Windows Seven 02 04 05 27 49 59= 24 57 99
02 04 05 27 49 59
03 04 08 11 47 49
03 36 40 46 58 60
07 27 39 52 55 57
06 21 28 31 33 43
14 25 28 45 53 58
09 11 21 49 53 54
02 05 12 13 25 35
02 05 17 18 54 59
05 12 36 45 50 58
03 14 52 55 57 60
11 27 30 40 44 57
05 13 16 17 27 55
07 09 23 44 46 55
02 18 30 31 45 56
27 35 36 37 42 59
12 28 38 39 51 56
18 27 32 43 50 52
22 29 31 43 50 54
01 16 28 39 44 57
04 19 27 28 29 31
07 12 19 34 40 53
02 08 12 28 33 43
04 18 24 28 39 44
11 16 24 35 46 50
05 11 17 19 44 48
29 48 52 54 55 58
03 04 07 15 27 56
14 32 33 40 42 51
34 39 43 56 57 60
09 26 34 43 53 54

[jan]

because not answered the last questions, any questions? only comes mensagam warning.

[Excel Fox]

Can't make out the logic you are trying to explain. Can you rephrase?

[jan]

Hello, it is quite easy step .1 separate the last digit of the list results okstep 2, add the digits in every twoExampleResult =01 36 25 12 02 48 = join the last digit = 1.2 2.5 6.8So we have 6 digits together in twos we have 12 pairs 3 25 68Cause or other sweepstakes and option to put more sweepstakes, to separate macroIn the last 3 digit pairs