Can I randomize whole numbers in my excel sheet?

[Guest]

 

[N Harkawat]

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

 

[olasa]

You can use the =RANDBETWEEN(bottom,top)

Ol

 

[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