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.Originally Posted by jan
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.
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.
Posting Permissions
Reply With Quote
Bookmarks