Random

R

Rayc

Hello,

I'm using the function RANDBETWEEN(). When I drag this formula down i
gives me various random numbers between the range I nominate in th
formula.

Is there any way I can drag this formula down and not repeat any of th
previous random numbers displayed?

Any help would be appreciated.

Thanks

Ray
 
J

Jason Morin

A lot of code has been posted to accomplish the
generation of non-repeating random numbers. Here's an
example from MVP Tushar Mehta's site:

http://www.tushar-
mehta.com/excel/newsgroups/rand_selection/vba.html

Watch the wrap.

HTH
Jason
Atlatna, GA
 

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

RANDBETWEEN() 9
using randombetween to arrive at dollars and cents 3
Using =RANDBETWEEN(a,b) in a paers of a whole colume 1
random between function 8
How can I use the same random number twice in the same formula? 2
RANDBETWEEN generating numbers outside range 5
Using "=randbetween" to select a number from a range of cells 4
Weighted randbetween text list 3

Top