randbetween problem

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
Nick's picture

Kumar - he doesn't want

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

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