RAND() generates a value greater than or equal to 0, and less than 1. So
when multiplied by, say, 100 rows, the values returned will be in the
range 0 to 99.999999999999999.

Index truncates the result of the calculations, so to get rows 1 to 100,
one needs to add 1 to the 0 to 99 range.

In article ,
Richard Champlin wrote:

Thank you sir, this worked perfectly. I know it sounds uneducated, but it
is: what does the +1 do at the end of the formula? I simply changed the 100
to the last row in the list, and changed the last number in the formula to
match. What effect would it be to change the +1 to a +2, etc?
--
Richard Champlin
Administrative Program Assistant II
Children''''''''s Hospital & Regional Medical Center, Seattle


"JE McGimpsey" wrote:

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.