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
|