| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to random pick a cell from more than one column
"Shane Devenshire" wrote: Another solution is to use the ATP Sampling tool. You can sample from any range and return 1 entry or more. The ATP is attached by choosing Tools, Add-ins and checking Analysis ToolPak. Then choose the command Tools, Data Analysis, Sampling... I have Excel 2007, I tried to use the Data Analysis Sampling, but i get an error: "Input range contains non-numeric data" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pick a Random name from a list. | Excel Discussion (Misc queries) | |||
| Random pick of a cell | Excel Discussion (Misc queries) | |||
| Can excel pick a random cell from a column? | Excel Worksheet Functions | |||
| Pick a Random name from a list. | Excel Worksheet Functions | |||
| random pick names from the list | Excel Discussion (Misc queries) | |||
Threaded Mode
