ZRandom implements a high quality pseudo-random number generator for Excel
Editor: ZRandom implements a high quality Pseudo-random Number Generator for Microsoft Excel:

Use the high quality Mersenne Twister Algorithm to generate better pseudo-random numbers than the RAND() formula in Excel&Reg; and Rnd() function in VBA.
Generate random numbers from 16 discrete and continuous distributions.
Formulas for use in spreadsheet cells.
A VBA interface to generate random numbers in your code.
Generate large amounts of random numbers interactive user interface.
Generate random samples from a table or random sort existing data. you can free download ZRandom 1.2 now.