Random unique integers - problem

[DJF]

I grabbed this code from an old posting and converted it to 4.0.  It does what it is supposed to do - generate random unique integers.  But there is a problem - if I request a dataset longer than the max value it never finishes - just crunches for ever. (in Prime or 15) I can't figure out why it would do that.  Anyone see the fix? (or have another tool that generates unique integers?)

[DJF · Accepted solution]

Nevermind.  I guess I am asking the impossible.  You can't have 11 unique integers between 1 and 10, can you?  (In my defense, it's late saturday.)

[LucMeekes]

Add a first line:

if n>m  return error("Check your parameters.")

Luc

[DJF]

Good idea.  Slight twist, I just redefine the max number.  Here's my final version; added max/min range of values.

[Werner_E]

Here's a slightly different version using a utility function "IsElement" which of course could also be global to the sheet. It also deals with exchanged upper and lower limits.