| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
Select a random value from a column of values
Hi, I have never programmed Excel before, but do use it a fair amount,
including use of built-in formulae. I would like to be able to select a random value among a group of values - is this possible? So for example, in a spreadsheet I have in column A a list of names from cell 1 to cell 20. then I want to pick a name from random from that list. How would I do? Any input would be appreciated. -- Paul PS I do not have visual Studio/VB installed on my machine. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting random subset of values from one column into another | Excel Worksheet Functions | |||
| From Column select Values to sum | Excel Worksheet Functions | |||
| Function to select random values from a list. | Excel Worksheet Functions | |||
| Select top 5 in column A, sum values in B | Excel Worksheet Functions | |||
| Trying to select values in a column with blanks | Excel Programming | |||
Threaded Mode
