Randomly sort a set group of integers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Justin Peckner - 19 Jul 2007 19:46 GMT

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

Reply to this Message

Peo Sjoblom - 19 Jul 2007 19:53 GMT

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

Signature

Regards,

Peo Sjoblom

> Hello,
>
[quoted text clipped - 8 lines]
>
> -jpeckner

Reply to this Message

Mike H - 19 Jul 2007 19:54 GMT

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

> Hello,
>
[quoted text clipped - 5 lines]
>
> -jpeckner

Reply to this Message

Bernd Plumhoff - 19 Jul 2007 19:56 GMT

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

Reply to this Message