If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Random non-duplicating numbers
I know there is a lot of Q&A on this subject online but I haven't got
any to work on my Excel 2003. I need to create random integers (up to 160,000) that do not duplicate. Actually it would be even better to have something that randomly chooses (non-duplicating) cells from another worksheet (ex. choose randomly A140000, unless the cell is blank), but I can do the rest of the leg work on my own if that is too complicated for me to understand. I plan to learn more at some point, but my VBA knowledge consists of being able to copy and past code, and when that doesn't work, I'm stuck. Thanks! k |
#2
|
|||
|
|||
Random non-duplicating numbers
On Feb 13, 12:29*am, Kerry wrote:
I know there is a lot of Q&A on this subject online but I haven't got any to work on my Excel 2003. I need to create random integers (up to 160,000) that do not duplicate. Actually it would be even better to have something that randomly chooses (non-duplicating) cells from another worksheet (ex. choose randomly A140000, unless the cell is blank), but I can do the rest of the leg work on my own if that is too complicated for me to understand. I plan to learn more at some point, but my VBA knowledge consists of being able to copy and past code, and when that doesn't work, I'm stuck. Thanks! k I think I figured out an easy method. I decided to just randomly generate non-random numbers, assign each value with an integer (e.g. 1 thru 160,000 if I have 160,000 random numbers), and then sort the integers by their non-random partner values. The only issue is b/c I have over 160,000 values I need to sort over to columns, which I'm not sure I can do at this point. I'm still looking into it, though. Thanks, k |
#3
|
|||
|
|||
Random non-duplicating numbers
On Feb 13, 1:58*am, Kerry wrote:
On Feb 13, 12:29*am, Kerry wrote: I know there is a lot of Q&A on this subject online but I haven't got any to work on my Excel 2003. I need to create random integers (up to 160,000) that do not duplicate. Actually it would be even better to have something that randomly chooses (non-duplicating) cells from another worksheet (ex. choose randomly A140000, unless the cell is blank), but I can do the rest of the leg work on my own if that is too complicated for me to understand. I plan to learn more at some point, but my VBA knowledge consists of being able to copy and past code, and when that doesn't work, I'm stuck. Thanks! k I think I figured out an easy method. I decided to just randomly generate non-random numbers, assign each value with an integer (e.g. 1 thru 160,000 if I have 160,000 random numbers), and then sort the integers by their non-random partner values. The only issue is b/c I have over 160,000 values I need to sort over to columns, which I'm not sure I can do at this point. I'm still looking into it, though. Thanks, k Sorry, just want to edit this to avoid any confusion: I said above that I "...assign each value with an integer" but this is superfluous. All I do is get 160,000 random numbers, which I place in a column next to my real values I want to pair them with, then I sort both columns by the rand # values. This should randomize my real values, which is all I needed to accomplish. |
Thread Tools | |
Display Modes | |
|
|