Number Generator Example.xlsm

	A	B	C	D	E	F	G	H	I	J	L	M	O	P	Q	R	S	U	W	X	AA
1	Examples of Frequency & Random
2
3		Column1	Column2	1	2	3	4	5	6	Random	Selections	Frequency	Highest Frequencies			Number of Random Numbers Required :
4				2	13	27	28	35	47	0.5975028477	1	#NAME?	#1	#NAME?		1
5				4	7	8	14	33	47	0.3306735785	2		#2	#NAME?
6				11	13	19	20	27	30	0.02739741024	3		#3	#NAME?
7				9	32	33	34	38	43	0.1768753327	4		#4	#NAME?
8				9	18	24	37	40	45	0.8575209679	5		#5	#NAME?
9				12	18	27	32	44	45	0.05334289086	6
10				3	11	23	25	34	44	0.4304031971	7
11				12	16	17	22	28	39	0.5870913914	8
12				1	3	5	25	28	37	0.6550729442	9
13				6	11	13	31	34	37	0.6371841922	10		Number Selections Based On Highest Frequencies					Combine Selections			Select Cell Below to pate
14				14	16	17	21	25	48	0.07792764248	11		1	2	3	4	5		47	47	47
15				22	30	32	37	42	44	0.5851034872	12								37	37	37
16				6	26	32	36	40	45	0.9711245997	13								2	2	2
17				4	13	30	37	43	47	0.9658901211	14								1	1	1
18				1	3	6	16	19	27	0.6177851037	15								10	10	10
19				3	8	19	24	25	47	0.4120210468	16										43
20				21	24	26	38	40	48	0.731232285	17								43	43	3
21				9	10	16	17	34	36	0.9016104598	18								3	3	6
22				2	9	10	15	19	41	0.4259260735	19								6	6	11
23				1	7	12	33	41	46	0.4631815174	20								11	11	7
24				1	2	16	18	36	45	0.5833409756	21										13
25				15	21	24	37	38	45	0.5046898997	22										12
26				5	9	13	34	47	48	0.1899570297	23								7	7	9
27				2	8	27	30	31	47	0.03379112879	24								13	13	17
28				7	17	24	31	32	44	0.1838083529	25								12	12	20
29				10	23	24	30	35	49	0.2784253961	26										24
30				6	13	14	15	18	47	0.9904561718	27										18
31				4	18	20	21	29	36	0.2168883204	28								9	9	36
32				3	15	18	33	38	40	0.183406817	29								17	17	30
33				7	23	26	27	44	48	0.8475141846	30								20	20	19
34				2	19	27	43	47	49	0.05489019062	31										45
35				2	33	35	36	40	47	0.1630803418	32										38
36				17	19	37	38	39	49	0.6127767404	33								24	24	21
37				7	12	31	35	39	43	0.8778402084	34								18	18	48
38				19	29	30	40	41	43	0.1760916616	35								36	36	40
39				20	23	28	35	43	44	0.01011874155	36										23
40				1	12	22	23	41	48	0.388561943	37										25
41				3	5	7	20	24	48	0.6156997724	38								30	30	27
42				9	10	13	20	43	46	0.9360046168	39								19	19	31
43				12	26	33	38	47	49	0.8524614443	40								45	45	32
44				1	7	17	25	35	43	0.3838624403	41										33
45				10	21	31	35	37	46	0.3311647032	42										34
46				3	6	9	11	23	43	0.456164578	43								38	38	35
47				9	11	21	31	32	34	0.4578831672	44								21	21	44
48				7	15	18	20	22	40	0.3826140575	45								48	48
49				2	17	40	41	42	45	0.4278208121	46
50				1	5	6	10	39	44	0.0379804087	47
51				6	11	21	32	33	46	0.3063601994	48								40	40
52				8	23	24	31	47		0.8947328797	49								23	23
53				4	26	36	37	38		0.4899079374
54				3	8	14	30	46		0.9787375342
55				5	14	25	30	38		0.9258689894
56				2	22	25	34	42		0.2473377676
57																			25	25
58
59
60
61
62																			27	27
63
64
65
66
67																			31	31
68
69
70
71
72																			32	32
73
74
75
76
77																			33	33
78
79
80
81
82																			34	34
83
84
85
86
87																			35	35
88
89
90
91
92																			44	44
93
94
95
96
97
98
99
100