Home » Forums » Open Source Learning Center » Question and Answer

randbetween problem

Submitted by shane68 on 8 August, 2012 - 00:07

Hello, I'm trying to figure out how to random pick numbers 0 - 9 in ten
different cells with the numbers in each cell being one of each number
without duplicaing within the ten cells. Any help or ideas would be greatly
appreciated.
Thank you for your time.
Shane

AttachmentSize
randomZeroTo9.xls77.5 KB
‹ Display worksheet name into another worksheet based on a condition Search for "yes" in a cell, then copy information from other cells to another tab ›
»
Nick's picture

Kumar - he doesn't want

Submitted by Nick on 8 August, 2012 - 08:44.
Kumar - he doesn't want dupes. Shane, I have added a solution to your original post. Click one of these "Like" buttons this helps..

Nick
»

randbetween problem

Submitted by 0713910067 on 8 August, 2012 - 06:04.

simply use " =RANDBETWEEN(0,9) " in 1 cell and drag it into 10 cells where ever you want.

»