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