Randon number distribution/generator help please.
 

Premise;

I want to randomly number the cells in a single column, 999 rows high using
the numbers 1 thru 999.

How do I randomly distribute the number 1 thru 999 to the 999 cells in this
column using each number only once?

Given my math skills I have not been able to do this using Excel: RAND,
RANDBETWEEN, of RANDOM_worksheet_Function.

I'm sure it's me, not the capabilities of Excel.

Objective;

After generating the list of 999 randomly distributed numbers, they will be
combined (cut/paste) with an alphabetized list of names.

I will then sort the data using the number field to generate a numerical
indexed randomized list of names rather than an alphabetized list of names

Thanks in advance for any help that you can provide.

--
Larry

Randon number distribution/generator help please.
 

Larry -

If you're going to do this just once, a simple way is to use a adjacent
helper column filled with =RAND(). Select both columns, and choose Data |
Sort ...

(If you're bothered that RAND recalculates after the sort, use Copy and
Paste Special | Values before the sort.)

Perhaps you can avoid the "1 thru 999" completely by using the same helper
column adjacent to the list of names.

- Mike
http://www.mikemiddleton.com

"larry" wrote in message
...
Premise;

I want to randomly number the cells in a single column, 999 rows high
using
the numbers 1 thru 999.

How do I randomly distribute the number 1 thru 999 to the 999 cells in
this
column using each number only once?

Given my math skills I have not been able to do this using Excel: RAND,
RANDBETWEEN, of RANDOM_worksheet_Function.

I'm sure it's me, not the capabilities of Excel.

Objective;

After generating the list of 999 randomly distributed numbers, they will
be
combined (cut/paste) with an alphabetized list of names.

I will then sort the data using the number field to generate a numerical
indexed randomized list of names rather than an alphabetized list of names

Thanks in advance for any help that you can provide.

--
Larry

Randon number distribution/generator help please.
 

Hi,

One way would be to use a helper column, in a blank (helper) column type
=RAND() and copy down to the last row, then use the small or large function
in another column.......=LARGE($A$1:$A$999,ROW(A1)) and copy down.

Hope this helps!
Jean-Guy

"larry" wrote:

Premise;

I want to randomly number the cells in a single column, 999 rows high using
the numbers 1 thru 999.

How do I randomly distribute the number 1 thru 999 to the 999 cells in this
column using each number only once?

Given my math skills I have not been able to do this using Excel: RAND,
RANDBETWEEN, of RANDOM_worksheet_Function.

I'm sure it's me, not the capabilities of Excel.

Objective;

After generating the list of 999 randomly distributed numbers, they will be
combined (cut/paste) with an alphabetized list of names.

I will then sort the data using the number field to generate a numerical
indexed randomized list of names rather than an alphabetized list of names

Thanks in advance for any help that you can provide.

--
Larry

Randon number distribution/generator help please.
 

Oops.....I meant the RANK function.....=RANK(A1,$A$1:$A$999)

sorry for the misunderstanding!

Regards
Jean-Guy

"pinmaster" wrote:

Hi,

One way would be to use a helper column, in a blank (helper) column type
=RAND() and copy down to the last row, then use the small or large function
in another column.......=LARGE($A$1:$A$999,ROW(A1)) and copy down.

Hope this helps!
Jean-Guy

"larry" wrote:

Premise;

I want to randomly number the cells in a single column, 999 rows high using
the numbers 1 thru 999.

How do I randomly distribute the number 1 thru 999 to the 999 cells in this
column using each number only once?

Given my math skills I have not been able to do this using Excel: RAND,
RANDBETWEEN, of RANDOM_worksheet_Function.

I'm sure it's me, not the capabilities of Excel.

Objective;

After generating the list of 999 randomly distributed numbers, they will be
combined (cut/paste) with an alphabetized list of names.

I will then sort the data using the number field to generate a numerical
indexed randomized list of names rather than an alphabetized list of names

Thanks in advance for any help that you can provide.

--
Larry

Randon number distribution/generator help please.
 

Mike,
Thanks for the reply,
--
Larry


"Mike Middleton" wrote:

Larry -

If you're going to do this just once, a simple way is to use a adjacent

I am going to have to do this more than once. I would want to recalculate
the number each time before copy and pasting them to the working page that I
will print from.

Not sure what a helper column is, sorry going to need lots of help.

helper column filled with =RAND().

When I did this I got random number, with a value less than one to eight
places

Select both columns, and choose Data |
Sort ...

(If you're bothered that RAND recalculates after the sort, use Copy and
Paste Special | Values before the sort.)

I would prefer that Rand not recalculate after the sort.

Perhaps you can avoid the "1 thru 999" completely by using the same helper
column adjacent to the list of names.

I will need the 1 thru 999 numbers


- Mike
http://www.mikemiddleton.com

"larry" wrote in message
...
Premise;

I want to randomly number the cells in a single column, 999 rows high
using
the numbers 1 thru 999.

How do I randomly distribute the number 1 thru 999 to the 999 cells in
this
column using each number only once?

Given my math skills I have not been able to do this using Excel: RAND,
RANDBETWEEN, of RANDOM_worksheet_Function.

I'm sure it's me, not the capabilities of Excel.

Objective;

After generating the list of 999 randomly distributed numbers, they will
be
combined (cut/paste) with an alphabetized list of names.

I will then sort the data using the number field to generate a numerical
indexed randomized list of names rather than an alphabetized list of names

Thanks in advance for any help that you can provide.

--
Larry

Randon number distribution/generator help please.
 

Pinmaster

Thank I think I made it work
--
Larry


"pinmaster" wrote:

Hi,

One way would be to use a helper column, in a blank (helper) column type
=RAND() and copy down to the last row, then use the small or large function
in another column.......=LARGE($A$1:$A$999,ROW(A1)) and copy down.

Hope this helps!
Jean-Guy

"larry" wrote:

Premise;

I want to randomly number the cells in a single column, 999 rows high using
the numbers 1 thru 999.

How do I randomly distribute the number 1 thru 999 to the 999 cells in this
column using each number only once?

Given my math skills I have not been able to do this using Excel: RAND,
RANDBETWEEN, of RANDOM_worksheet_Function.

I'm sure it's me, not the capabilities of Excel.

Objective;

After generating the list of 999 randomly distributed numbers, they will be
combined (cut/paste) with an alphabetized list of names.

I will then sort the data using the number field to generate a numerical
indexed randomized list of names rather than an alphabetized list of names

Thanks in advance for any help that you can provide.

--
Larry