Randomly select four names from a list of names

[n1guidon]

I need to create a function that selects 4 names randomly from a list of 15 names and displays the 4 randomly selected names in the one cell. Also, you cannot repeat the same name in that cell, (i.e. bob cannot be selected twice in his group of four)

 

[PaddyD]

Hi - welcome to the board.

I'd do it long-hand:

1) add a random key =rand()
2) rank set on the random key
3) produce the name list via index / match
4) concatenate