Genrate random number without repeat in one formula

[sohaila]

hello
I want Generate random number in given number number without duplication in three cells in one formula
like give number
2 result
5 60
10 5
60 40
11 with out duplication
40
16
Is it possible?
thanks

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C
1
2	2		60
3	5		2
4	10		40
5	60
6	11
7	40
8	16
Main

Cell Formulas
Range	Formula
C2:C4	C2	=INDEX(SORTBY(A2:A8,RANDARRAY(ROWS(A2:A8))),{1;2;3})
Dynamic array formulas.

 

[sohaila]

Thanks for your replay is it possiable without sortby and randarray function

 

[Fluff]

Not that I know with a single formula. Why?

 

[Peter_SSs]

is it possiable without sortby and randarray function

Like this?

22 01 25.xlsm
	A	B	C
1
2	2		60
3	5		2
4	10		5
5	60
6	11
7	40
8	16
9
Random

Cell Formulas
Range	Formula
C2:C4	C2	=INDEX(A$2:A$8,AGGREGATE(15,6,((ROW(A$2:A$8)-ROW(A$2)+1)/ISNA(MATCH(A$2:A$8,C$1:C1,0))),RANDBETWEEN(1,ROWS(A$2:A$8)-COUNT(C$1:C1))))

 

[sohaila]

Thanks it work perfect great job

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.