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