Random non-duplicating numbers

  • Thread starter Thread starter Kerry
  • Start date Start date
K

Kerry

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 A1:D40000, 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 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 A1:D40000, 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
Click to expand...

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
 
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
Click to expand...

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.
 
Back
Top