LOTTERY SREADSHEET

[fsjenkins2000]

need help with lottery functions /need to find the most recurring numbers/ least recurring numbers/ and if number sequence has already occured/

range A,B,C,D,E,F
6 number lottery
numbers 1-52
[/img]

 

[Dutchy]

If you have 100 lottery results in rows 2 to 101 then how about something like this? (I've only shown the top 10 rows, of course it goes down further)

Book1
	A	B	C	D	E	F	G	H	I	J
1								Number	Frequency	Min/Max
2	4	10	13	23	34	39		1	19
3	12	13	14	18	19	27		2	15
4	1	2	17	34	35	51		3	13
5	7	4	10	16	27	34		4	20	max
6	8	14	28	32	34	43		5	6	min
7	3	10	21	25	32	52		6	12
8	7	13	16	23	42	40		7	17
9	1	2	3	8	14	36		8	15
10	7	8	12	13	33	44		9	14
Sheet1

Column H has 1-52
I2 has formula =COUNTIF($A$2:$F$101,H2)
J2 has formula =IF(I2=MAX($I$2:$I$53),"max",IF(I2=MIN($I$2:$I$53),"min",""))

these should both be copied down to row 53

Are your lottery numbers sorted, i.e. with the lowest number in column A, highest in F?