From: Dennis Tucker on 14 Mar 2010 19:14 What is the best method to make a list of randomized(non-repeating) numbers between a start value and a end value? From: joel on 14 Mar 2010 20:30 The best method is to use a 2 dimensional array (or two columns in a spreadsheet). put the numbers you want to sort in one column and then put a random number in the 2nd column. Finaly sort the 2 columns by the random number column. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=187459 http://www.thecodecage.com/forumz/chat.php From: L. Howard Kittle on 14 Mar 2010 20:57 You could try something like this, will give a unique list of random numbers between 1 and 32 listed in A1A20. Change the c.Value = to suit the range of start and end numbers and adjust the range for the list to suit. Do not know if it is the best as you request. Sub sonic1to32() Dim FillRange As Range, c As Range Set FillRange = Range("A1:A20") For Each c In FillRange Do c.Value = Int((32 * Rnd) + 1) Loop Until WorksheetFunction.CountIf(FillRange, c.Value) < 2 Next End Sub HTH Regards, Howard "Dennis Tucker" wrote in message news:%23ZbJHw8wKHA.812(a)TK2MSFTNGP06.phx.gbl... What is the best method to make a list of randomized(non-repeating) numbers between a start value and a end value? From: Dennis Tucker on 14 Mar 2010 21:13 I like this method so far. "joel" wrote in message news:joel.47ual9(a)thecodecage.com...> > The best method is to use a 2 dimensional array (or two columns in a > spreadsheet). put the numbers you want to sort in one column and then > put a random number in the 2nd column. Finaly sort the 2 columns by > the random number column. > > > -- > joel > ------------------------------------------------------------------------ > joel's Profile: 229 > View this thread: > http://www.thecodecage.com/forumz/showthread.php?t=187459 > > http://www.thecodecage.com/forumz/chat.php > From: marcus on 14 Mar 2010 21:18 Hi Denis Say your start value is 10 and your end value is 20. This formula will give you non matching numbers between these two points. =RAND()*(20-10)+10 Take care Marcus  |  Next  |  Last Pages: 1 2 Prev: NCAA Bracket in ExcelNext: LookUp If Greater Than and LessThan