LOTTERY SREADSHEET

fsjenkins2000

New Member
Joined
Feb 24, 2005
Messages
7
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]
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Dutchy

Well-known Member
Joined
Sep 18, 2004
Messages
560
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
ABCDEFGHIJ
1NumberFrequencyMin/Max
241013233439119 
3121314181927215 
41217343551313 
57410162734420max
68142832344356min
731021253252612 
871316234240717 
912381436815 
107812133344914 
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,518
Messages
5,596,630
Members
414,082
Latest member
sasmita

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top