The best way is to pull it all into an array, then have a random number
generated that is one of the indexes of the array. If you can tell me more
about what sheet name and column the data is on and in what row and column I
can set something up for you if needed.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"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.
--
Richard Champlin
Administrative Program Assistant II
Children's Hospital & Regional Medical Center, Seattle