Hi

I am looking for a formula to select 5 random cell entries from a list in column A in Excel and put them in 5 cells say in column B.

I have a list of resturants in column A, and I want to select a random resturant to go in 5 cells, but a resturant can only appear once in those 5 cells.

Can anyone help?