I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

sbRandInt

If you want to generate non-repeating random integers between two given values I suggest to use my UDF sbRandInt:

20110322_PB_01_sbRandInt_Screen

If you are interested in downloading a 26 KB Excel 2010 sample file go to my Download page, please.

You can also generate random integers which may appear repeatedly up to lRept times:

20110322_PB_02_sbRandInt_Screen
20110322_PB_01_sbRandInt_Code
20110322_PB_02_sbRandInt_Code
20110322_PB_03_sbRandInt_Code
Sulprobil   Get it done   Contact   Disclaimer   Download