Pick names at random

[Memphis28]

Hi guys.

This is my first post but hopefully not my last.

I have a query regarding a random name picker that i'm trying to set up and i'm hoping someone can help.
Basically i am trying to make the placement of staff in the venue i run as random as possible. We tend to find clicks of certain people always being together and this is counter productive. What i would like is for the nightly till plan to fill itself in, in a way. When i open the till plan i want the spreadsheet to allow me to assign names picked at random from a list in to specific cells on the spreadsheet. Obviously it can't repeat names.
I have included a basic copy of what the till plan will look like and RANDOM NAME indicates where the name of the randomly picked staff member needs to go.

TIll 1	POSITION	START TIME
RANDOM NAME	BAR
RANDOM NAME	BAR
RANDOM NAME	BAR
RANDOM NAME	BAR
Till 2
RANDOM NAME	BAR
RANDOM NAME	BAR
RANDOM NAME	BAR
RANDOM NAME	BAR

<tbody>
</tbody>

Does anyone know how i could set this up. The staff will change from night to night so the list with staff names will have to editable. Also the number of staff working will also vary so the spreadsheet some nights will only be dealing with 13 names and on others 20 names. This is why i said the boxes the random name is placed in to are specific. In an ideal world each cell would have some button or command of sorts that tells it to pick a random name from the list so i can just fill in as many cells as there are staff.

Anyway i hope this makes sense and that you can help.
Thank you in advance

Memphis

 

[TheCman81]

HI and welcome

You could create a list of names (I've used column G for this purpose) withthe following formula in Column H =RAND()

Then use the following formula to create a list to random names form that list

=INDEX($G$1:$G$8,MATCH(LARGE($H$1:$H$8,ROWS($A$2:A2)),$H$1:$H$8,0))

Hope this helps