Richard Champlin -

The RandSample function (one of the random number generator functions in the
RiskSim add-in for Monte Carlo simulation) will select a sample without
replacement from a single row or column of values. You can download a free
tryout version and user guide from www.treeplan.com.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"Richard Champlin" wrote in
message ...
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