Random Number Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve Boyle - 26 Feb 2008 04:05 GMT

Does anyone have a Random Number Formula for creating the following

Random Numbers in 52 different cells with no number repeated

Yes I am working on a Poker Rally and need to generate score cards that are
different and Random

Steve Boyle

By the way thanks for the help on my last question. If I ever remember to
take the print out to work and try the answers I will let you know how well
it worked.

Reply to this Message

John Wilson - 26 Feb 2008 04:21 GMT

Steve,

This should be exactly what you need.
http://tinyurl.com/2jgd8d

John Wilson

> Does anyone have a Random Number Formula for creating the following
>
[quoted text clipped - 8 lines]
> take the print out to work and try the answers I will let you know how
> well it worked.

Reply to this Message

Jim Cone - 26 Feb 2008 04:29 GMT

No formula, but I do have a free random number workbook available.
More details on it at the bottom of the Products page at my website.
Free upon request to those who provide a real name and geographic location.

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Steve Boyle"
wrote in message
Does anyone have a Random Number Formula for creating the following

Random Numbers in 52 different cells with no number repeated

Yes I am working on a Poker Rally and need to generate score cards that are
different and Random

Steve Boyle

By the way thanks for the help on my last question. If I ever remember to
take the print out to work and try the answers I will let you know how well
it worked.

Reply to this Message

joeu2004 - 26 Feb 2008 04:49 GMT

> Does anyone have a Random Number Formula for creating
> the following[:]
> Random Numbers in 52 different cells with no number repeated

One way:

1. Put =RAND() into A1:A52.

2. In any column (C3:C54, for example), put the following into the
first cell and copy down:

=rank(A1,$A$1:$A$52)

Caveat: Since RAND() is volatile, C3:C54 will change every time you
make any change to the workbook. If that bothers you, use copy-and-
paste-special-value to take a snapshot of C3:C54.

> Yes I am working on a Poker Rally and need to generate score
> cards that are different and Random

So, I am not sure the above meets your needs.

Reply to this Message

Bernd P - 26 Feb 2008 06:04 GMT

Hello,

I suggest to search for UniqRandInt in this group.

It can even cope with 2 decks.

Regards,
Bernd

Reply to this Message