| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
Select a random value from a column of values
Or, if you don't want to rely on an Analysis Toolpak function:
=INDEX(A:A,RAND()*20+1) In article , "Frank Kabel" wrote: another way: =INDEX(A1:A20,RANDBETWEEN(1,20)) |
| 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
