Generate a random list

[myxmaster]

I am trying to achieve the following. Column A has a list of names. I
would like to randomly assign a letter to each name in column B ,
however as column a is a variable the list size will vary.
Any help is most appreciated

 

[Ragdyer]

Let's start with using an out-of-the-way location of your sheet to set up
the alphabet.

Say in Z1 to Z26, you enter the alphabet.
In Y1, enter this formula:
=Rand()
And copy it down to Y26.

With your list starting in A1, enter this formula in B1:

=INDEX(Z$1:Z$26,RANK(Y1,Y$1:Y$26))

I don't see where the length of your list is a problem.

Just copy the formula down Column B, as far as there are names in Column A.

Now, each time you hit <F9>, you'll get a new random letter display in
Column B, next to the name list in Column A.

If you wish, you can copy *THIS* formula down Column B, past the row that
contains the last name in Column A, and it will cause Column B to remain
blank until a name is added to Column A:

=IF(A1="","",INDEX(Z$1:Z$26,RANK(Y1,Y$1:Y$26)))