Prev: Set highlighted numbers in a graph
Next: plot highlight
From: Kerry on 13 Feb 2010 00:29
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
From: Kerry on 13 Feb 2010 01:58
On Feb 13, 12:29 am, Kerry <kbro...(a)gmail.com> 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 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 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
From: Kerry on 13 Feb 2010 02:35
On Feb 13, 1:58 am, Kerry <kbro...(a)gmail.com> wrote:
> On Feb 13, 12:29 am, Kerry <kbro...(a)gmail.com> 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 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 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.
 | 
Pages: 1
Prev: Set highlighted numbers in a graph
Next: plot highlight