View Single Post
  #1   Report Post  
SammyJJones SammyJJones is offline
Junior Member
 
Posts: 8
Question Select random cell

Simple to explain... probably not as easy to do.... please help!

I have 30 peoples names listed from A1 to A30.... I want excel to randomly select one of these names and display it in cell C1.

I know there are long ways to do it, but I'd like it to generate a new random name every time I hit F9 (refresh) or click on something else.

Thank you in advance
Sammy