I am a supporter ofSt. Joseph's hospice. If you find this site useful or if it helped you, consider a small donation toSt. Joseph's, please.
Information onSt. Joseph's
If you want to generate non-repeating random integers between two given values I suggest to use my UDF sbRandInt:
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: