Thread: Randomly choose x numbers from y data block
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tushar Mehta[_5_] Tushar Mehta[_5_] is offline
external usenet poster
  
Posts: 2
Default Randomly choose x numbers from y data block
Adding one more to the alternatives already posted {grin}
Select elements at random without repetition
http://www.tushar-mehta.com/excel/ne...ion/index.html


On Sat, 18 Jul 2009 19:21:01 -0700, Steve
wrote:

I need a macro to select at random x numbers (non-repeating) from a matrix of
y cells and store them in an array.

Regards,

Tushar Mehta
Microsoft MVP Excel 2000-2008
www.tushar-mehta.com
Tutorials and add-ins for Excel, PowerPoint, and other products
Reply With QuoteReply With Quote