Random numbers

[MPC64]

I need to randomise numbers 1 to 12 using the RANDBETWEEN(1,12) but I need each number represented once. When I do this in a column format I get numbers repeated more than once. Is there a way of having 1-12 in column A and then in column B randomise those 12 numbers so that each is represented once?

 

[GraH]

Perhaps like so

Book1
	A	B	C
1	1	0,200265	11
2	2	0,139371	12
3	3	0,357932	8
4	4	0,528355	6
5	5	0,512184	7
6	6	0,718308	3
7	7	0,899221	2
8	8	0,285592	9
9	9	0,678374	4
10	10	0,672819	5
11	11	0,905521	1
12	12	0,223373	10
Sheet1

Cell Formulas
Range	Formula
B1:B12	B1	=RAND()
C1:C12	C1	=RANK(B1,$B$1:$B$12,0)

 

[MPC64]

Brilliant - thank you - not sure what the formula in C does but it works and that's all I need!

 

[Yongle]

Welcome to the forum
One way, using =RAND()

Book1
	A	B
1	0.755728502	5
2	0.123296816	3
3	0.882945971	10
4	0.205367896	6
5	0.897917073	1
6	0.779716125	9
7	0.411101788	7
8	0.022704301	11
9	0.722536502	12
10	0.809076078	4
11	0.331114856	2
12	0.24517602	8
Sheet1

Cell Formulas
Range	Formula
A1:A12	A1	=RAND()
B1:B12	B1	=MATCH(LARGE($A$1:$A$12,ROW(A1)),$A$1:$A$12,0)

EDIT
- just spotted @GraH suggestion which is very similar

 

[MPC64]

Thanks - not really clarified it but I don't really need to know the workings. I just need a list of numbers 1-12 which are randomised so however it gets there that's fine by me!

 

[GraH]

Brilliant - thank you - not sure what the formula in C does but it works and that's all I need!

Try the inner help... It simply ranks (orders) a value in a list of values.