Without VBA generate random unique numbers

[jamiguel77]

hi all, is possible?
Without VBA generate random unique numbers

use solver?

thanks

 

[Peter_SSs]

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Peter_SSs]

Further to my previous point. Suppose you want to generate up to 20 unique random numbers from 100 to 119.
If you have Excel 365 with the SEQUENCE function then you can try the column A formula below. For any version from Excel 2000 on try the column C formula

20 10 20.xlsm
	A	B	C
1	Excel 365 with SEQUENCE Fn		Excel 2000+
2	100		117
3	101		104
4	103		118
5	107		106
6	108		110
7	106		105
8	104		102
9	110		114
10	116		119
11	109		108
12	119		112
13	118		109
14	111		107
15	113		113
16	112		115
17	102		101
18	115		111
19	114		100
20	117		103
21	105		116
Random Unique

Cell Formulas
Range	Formula
A2:A21	A2	=AGGREGATE(15,6,SEQUENCE(20,,100)/ISNA(MATCH(SEQUENCE(20,,100),A$1:A1,0)),RANDBETWEEN(1,20-COUNT(A$1:A1)))
C2:C21	C2	=AGGREGATE(15,6,ROW(INDEX(C:C,100):INDEX(C:C,119))/ISNA(MATCH(ROW(INDEX(C:C,100):INDEX(C:C,119)),C$1:C1,0)),RANDBETWEEN(1,20-COUNT(C$1:C1)))