Thanks for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"mcmil" wrote in message
...
thanks alot guys both seem to work well. i really appreciate your help
and
i'll probably have more questions later i imagine.
again thanks.

"Bernd Plumhoff" wrote:

Hello,

I suggest to use my function UniqRandInt().

Then you might enter (as array formula - enter with CTRL + SHIFT +
ENTER):
=index(a73:a173,uniqrandint(100))

HTH,
Bernd