Shoot it over. Are you wanting to select 1 item from each column or treat all
3 as one list?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Richard Champlin" wrote:

I have three columns of numbers, from Row 3 to row 863 (the last column is
shorter). Each column contains 5-digit integers. The first column contains
item numbers that are not consecutive, that start with 10009 and end with
11180, the second that start with 11181 and end with 21212, and the third
that start with 21213 and end with 29048. The numbers are not consecutive.
The reason for three columns is that these are filtered from a longer list
which is too long to allow a data filter to work.

How about if I e-mail you a copy?

Richard Champlin
Administrative Program Assistant II
Children's Hospital & Regional Medical Center, Seattle


"John Bundy" wrote:

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