If it's sufficient when every outcome can only happen once every 1 million times (which isn't very random imo) use RAND.
The RAND function returns numbers from the interval [0,1), and if you need to generate numbers from another interval, you should use the following formula:
Code:
=RAND() * (b−a) + a
This will return random numbers from the interval [a,b) - greater than or equal to a, and less than b.
Otherwise, as it's only 32 numbers, you can use
www.random.org for the ease of it.
Make sure your MSoffice has all updates, there were numerous bugs with RAND, like returning negative numbers (wtf?).
Last edited by wellju; 08-03-2010 at 09:37 PM.
Reason: slow pony I is