If you want 8 unique numbers, you may have to code it up to do so.
Bob
![]() | Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years. Thanks, CNET Support |
I want to generate 8 different random numbers between 1 & 99 in Excel 2007.
I put formula =RANDBETWEEN(1,99) in cell A1 and then using the Fill Handle, Drag down fill A1:A8.
Each time I want a new set of numbers I then just press F9 on the keyboard. This obviously produces 8 numbers between 1 & 99, but often the same number is repeated in the selection. How do I tell Excel, as simply as possible, that I do not want to repeat a number in the selection?
Thanks Mike7P
Discussion is locked
mastered coding yet so will need to get some practice in soon.Anybody out there got any hints where to start.
Thanks
Mike7P
I found this page http://www.ozgrid.com/VBA/RandomNumbers.htm just after my last post. Looks like I may be in luck.
Thanks again.
Mike7P