Hello,

I suggest to take my function UniqRandInt() from www.sulprobil.com.

Then you can select cells A1:E5, array-enter
=UniqRandInt(99)
with CTRL+SHIFT+ENTER, for example, and the 25 cells A1:E5 will be filled
with unique (=non-repeating) random integers between 1 and 99.

HTH,
Bernd