Say, you want 10 random numbers between 1 to 100. Then you can use following formula
=INDEX(SORTBY(SEQUENCE(100), RANDARRAY(100)), SEQUENCE(10))
If rather than 1 to 100, then you can tweak SEQUENCE(100) accordingly. Say you need between 101 to 500. Then replace SEQUENCE(100) with
SEQUENCE(500-101+1, , 101) => Note here, 101 is start number and 500 is end number
Since 500-101+1 = 400 needs to be repeated in RANDARRAY also, hence better to use LET.
=LET(c, 500-101+1, INDEX(SORTBY(SEQUENCE(c), RANDARRAY(c)), SEQUENCE(10)))
