I know how to ask excel to randomly placea number from 1-10 in a cell. How can I have excel do this for 10 cells but not repeat a number?
Randomize an order
-
-
-
Re: Randomize an order
This may work for you
Code -
Re: Randomize an order
I don't think this can be done with formulas in the cell without iterative calculations turned on. If you are willing to use iterative calculations then you can take a look at http://www.mrexcel.com/forum/e…-non-matching-number.html and play around with the formula posted by Marcelo Branco.