=INT(RAND()*100) will generate 2 digit whole numbers
J JE McGimpsey Jun 14, 2005 #3 If you want non-repeating random numbers, see http://www.mcgimpsey.com/excel/randint.html for one way.
If you want non-repeating random numbers, see http://www.mcgimpsey.com/excel/randint.html for one way.
G Gord Dibben Jun 14, 2005 #4 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
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