Hello Jan,

Try this. Assuming numbers range is B2:B99

In B2,

=INT(RAND()*98+1)

In B3, with CTRL+SHIFT+ENTER, rather than just ENTER

=SMALL(IF(ISNA(MATCH(ROW(B$2:B$99)-ROW(B$2)+1,B$2:B2,0)),ROW(B$2:B$99)-ROW(B$2)+1),INT(RAND()*(98-ROWS(B$3:B3)))+1)

Then copy B3 & paste until B99. After Copy B2:B99 & paste to other columns.

This may slow down the calculation speed, especially if you have used in multiple rows & columns.

Hope this helps,
Haseeb