Can I randomize whole numbers in my excel sheet?

[AngeCP7]

[olasa]

You can use the =RANDBETWEEN(bottom,top)

Ola

[N Harkawat]

=INT(RAND()*100)
will generate 2 digit whole numbers


"AngeCP7" <[email protected]> wrote in message
news:[email protected]...
>

[JE McGimpsey]

If you want non-repeating random numbers, see

http://www.mcgimpsey.com/excel/randint.html

for one way.

[Gord Dibben]

Note: RANDBETWEEN requires the Analysis ToolPak add-in be loaded.

See also JE McGimpsey's site for limitations on the RANDBETWEEN function and
workarounds to ensure you get 100 non-duplicated numbers.

http://www.mcgimpsey.com/excel/udfs/randint.html





On Tue, 14 Jun 2005 08:58:17 -0500, olasa
<[email protected]> wrote:

>
>You can use the =RANDBETWEEN(bottom,top)
>
>Ola