| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you pull a random cell
I have a list of ten names and need to pull one randomly. Is there a way
that I can put a number 1-10 in a cell and it would randomly return one of the ten names? as an example if I put the number 2 in the cell it would populate the cell next to it with Name 1. If I cleared it and put a 2 in again it would populate the cell with Name 6 this time. Or is it possible to use a button (i.e. spin) to generate the first number and that would populate the name field? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| How do I pull a random sample of people from a list in excel? | Excel Worksheet Functions | |||
| Generate random numberes using reference to the other cell. | Excel Worksheet Functions | |||
| How do I set up a cell with a pull down list? | Excel Discussion (Misc queries) | |||
| copying cell names | Excel Discussion (Misc queries) | |||
Threaded Mode
