random numbers, how can you utilize it without repeating them

G

Guest

How can you use random numbers without repeating them on a worksheet? The way
it is set up now is, example: =RANDBETWEEN(1,8)
I would like to be able to use the random between but I don't want the
numbers to repeat themselves within the worksheet. Any suggestions or Ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multi, nested functions... 6
How to Restrict Random Numbers? 3
how do i insert numbers from Random list (1-60) without repeating 1
Influencing Random Numbers 1
Random numbers but with a bias 5
How can I fill a block of 300 cells with non-repeating random #s 2
generate whole differnt random numbers across cases or rows 1
Random Number 4

Top