See

http://www.mcgimpsey.com/excel/udfs/...noreplace.html

In article ,
Richard Champlin wrote:

Is it possible to create a random number generator that searches a list of
integers that are not consecutive, without generating a number that is not in
the list?

I would use it to randomly pick "X" number of items in a list to check for
inventory status, without having to verify that the random number generated
actually exists.