| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I select & use contents of first non-blank cell in row? | Excel Worksheet Functions | |||
| select a cell and the one next to it | Excel Discussion (Misc queries) | |||
| Generate random numberes using reference to the other cell. | Excel Worksheet Functions | |||
| In Microsoft Excel 2003, when I select a color for a cell it does. | Excel Worksheet Functions | |||
| Select part of a cell | Excel Worksheet Functions | |||
Threaded Mode
