Random Names and Numbers (non-repeating)

Here's one quick & dirty way. Add a column after the names in B. Fill it with

=RAND()

for as many lines as have names. Then column C put

=ROW()

also for every row. Then hit F9, and sort the whole sheet by column B. The names will be randomly arranged, and column C will always have the row numbers 1-12.

Hi mitchp and welcome to the forum,

Here is an example of what I think 6SJ is talking about. See the attached.

Precisely--the autofilter sort makes it easier also, nice touch.