Thread: How to random pick a cell from more than one column
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
fruitchunk fruitchunk is offline
external usenet poster
  
Posts: 35
Default 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"
Reply With QuoteReply With Quote