Randbetween with No Duplicates

Hello Everyone,
I have just joined the group and new to formulas.
I am trying to create a sheet to test times tables for my children.
I am using one column a constant number for ex: 4 and the next column for x sign and another for the =randbetween(0,12)
but the randbetween produces duplicates which defeats the purpose of testing all the range randomly.
Can someone help please.
Thanks

Welcome to the forum!

Have a look at this thread from 2013:

http://www.excelforum.com/excel-form...duplicate.html

By the way, as you are new to the forum, I have made your thread title more explicit for you this time. Next time, please do so yourself. Thanks!

Then you haven't understood the idea presented there. See the worked example attached - you can hide the third column.

Excel 2016 (Windows) 32 bit

	A	B	C	D
1	4	x	0.063219	12
2	4	x	0.213447	10
3	4	x	0.993647	1
4	4	x	0.222959	8
5	4	x	0.073212	11
6	4	x	0.345884	7
7	4	x	0.528815	6
8	4	x	0.692088	4
9	4	x	0.215054	9
10	4	x	0.616583	5
11	4	x	0.797066	2
12	4	x	0.741891	3

Sheet: Sheet1

Excel 2016 (Windows) 32 bit

	C	D
1	=RAND()	=RANK(C1,$C$1:$C$12)

Sheet: Sheet1

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Yes, that's what I suggested you do - hide the RAND() column. Glad to have helped!