Randomly sort a set group of integers

[Justin Peckner]

Hello,

I would like to randomly sort the numbers 1-35 in my worksheet. Each integer
is in its own seperate cell, which are currently arranged in descending order
in cells A1:A35. I tried selecting A1:A35 and using =UniqRandInt(35) as an
array (from http://www.sulprobil.com/html/uniqrandint.html), but every cell
returned "#NAME?". Any easy-to-follow help would be appreciated- thanks!

-jpeckner

 

[Peo Sjoblom]

It's UDF and you would need to install it first, that is why you get the
name error

http://www.mvps.org/dmcritchie/excel/install.htm

 

[Mike H]

Hi,

In B1 enter the formula

=Rand()

Double click the drag nagdle to fill down to A35
Select A&B columns and sort by column B
To get a different sort hit F9 and sort again.

Mike

 

[Bernd Plumhoff]

Hello,

Did you array-enter this formula (with CTRL + SHIFT + ENTER)?
And did you put the macro into a macro module (press ALT + F11, enter a
module, insert macro text)?

Regards,
Bernd