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