Prev: returning a text value
Next: Function to add name of Sheet to a Column?
From: Mike Middleton on 25 May 2010 17:14
Penny Black -

My ideas are the same as I posted in the microsoft.public.mac.office.excel
newsgroup:

(A) Early Excel 2003 had a serious bug in its random number generator. Be
sure to update to Excel 2003 SP3.

(B) You may want to avoid duplicates, in which case search Bing or Google
for "excel unique random numbers" (without the quotes).

- Mike
http://www.MikeMiddleton.com



"Penny Black" <PennyBlack(a)discussions.microsoft.com> wrote in message
news:9615C6E4-C2EC-4145-9725-CB702077B677(a)microsoft.com...
> Using Excel 2003. Simple task of trying to generate a pseudo-random
> number
> between 1 and 52 (yes, a deck of cards). I'm populating the cells with
> =RANDBETWEEN(1,52). Many of the cells are displaying negative numbers.
>
> Any ideas?
>
First  |  Prev  | 
Pages: 1 2
Prev: returning a text value
Next: Function to add name of Sheet to a Column?