Random Number Generator That Can Exclude Numbers

[Austin2550]

Hi,

I am fairly new to Excel, and I am looking to create a random number generator that can exclude random numbers (these random numbers are not always the same.) I need to create this in sets, for example, A 1 through 12, B 1 through 12, and so on. Would it be possible to have the excluded numbers between 1 and 12 typed into a range of cells, and have the other numbers generated into a different range of cells?

Thank you!

 

[HighAndWilder]

Hi,

I am fairly new to Excel, and I am looking to create a random number generator that can exclude random numbers (these random numbers are not always the same.) I need to create this in sets, for example, A 1 through 12, B 1 through 12, and so on. Would it be possible to have the excluded numbers between 1 and 12 typed into a range of cells, and have the other numbers generated into a different range of cells?

Thank you!

Hi,

I am fairly new to Excel, and I am looking to create a random number generator that can exclude random numbers (these random numbers are not always the same.) I need to create this in sets, for example, A 1 through 12, B 1 through 12, and so on. Would it be possible to have the excluded numbers between 1 and 12 typed into a range of cells, and have the other numbers generated into a different range of cells?

Thank you!

Are you able to use XL2BB to post an idea of what you have in mind looks like indicating any rules? XL2BB is on the editor ribbon.

 

[FormulasOnly]

If you do not have to large intervals you can specify the numbers you want to see:

MrExcel_Random Number Generator That Can Exclude Numbers.xlsx
	A	B	C	D	E	F	G	H
1	Input	1	1	2	1	7	1	6
2		2	3	4	2	8	2	7
3		3	5	6	3	9
4		4	7	8	4	10
5		5	9	10	5	11
6		6	11	12	6	12
7		7
8		8
9		9
10		10
11		11
12		12
13	Empty Row
14	Output	4	11	12	5	11	1	6
15		3	5	8	2	9	2	6
16		10	3	8	6	9	2	6
17		4	3	2	6	7	2	7
18		11	11	10	5	8	2	6
19		3	11	12	2	8	1	7
20		10	1	6	2	9	2	7
Random Numbers

Cell Formulas
Range	Formula
B14:H20	B14	=INDEX(B$1:B$13,RANDBETWEEN(1,COUNT(B$1:B$13)))