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
(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).
"Penny Black" <PennyBlack(a)discussions.microsoft.com> wrote in message
> Using Excel 2003. Simple task of trying to generate a pseudo-random
> 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?