Lottery Win Calculator

B

blarrabee

New Member
Joined
Jul 22, 2009
Messages
39
Platform
  1. MacOS
  2. Web
So I play the same 11 sets of #s in the megamillions every drawing. I was wondering if there is a relatively easy way to create a work sheet that would tell me if those numbers matched the winners.
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Sort by date Sort by votes
how do i use conditional formatting to compare a cell against 5 cells? it seems the limit is 3.
 
Upvote 0
Let's say you have your 11 sets in A3:F13 with the megaball in column F.

List the winning numbers in A1:F1 then select the range A3:E13 and use conditional formatting with this formula

=MATCH(A3,$A$1:$E$1,0)

format as required

Then select F3:F13 and use the formula

=F3=$F$1

and also format as required

That will highlight all matching numbers

You could also use a worksheet formula, e.g. in G3 copied down that would tell you how many matches you have, i.e.

=SUMPRODUCT(--ISNUMBER(MATCH(A3:E3,A$1:E$1,0)))&" + "&(F3=F$1)+0
 
Upvote 0
barry houdini said:
Let's say you have your 11 sets in A3:F13 with the megaball in column F.

List the winning numbers in A1:F1 then select the range A3:E13 and use conditional formatting with this formula

=MATCH(A3,$A$1:$E$1,0)

format as required

Then select F3:F13 and use the formula

=F3=$F$1

and also format as required

That will highlight all matching numbers

You could also use a worksheet formula, e.g. in G3 copied down that would tell you how many matches you have, i.e.

=SUMPRODUCT(--ISNUMBER(MATCH(A3:E3,A$1:E$1,0)))&" + "&(F3=F$1)+0
Click to expand...

I ended up with this:
=MATCH(A3,winningnumbers,0)
I created a named range.

Thanks for your help.

Any chance you can write a formula that will tell me what next weeks numbers will be?
 
Upvote 0
Any chance you can write a formula that will tell me what next weeks numbers will be?
Click to expand...
I can tell you they most likely will NOT be
6,7,9,12,18, & 4 because those are mine!!
Thanks for stepping in, Barry. The board went down before I could get back

lenze
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
Lottery results Belgium
Replies
2
Views
163
jacafate
J
N
  • Question
Auto Sort for Leaderboard
Replies
0
Views
102
NTLKnight
N
B
  • Solved
Rank winning percentage for sport game
Replies
9
Views
695
Peter_SSs
Peter_SSs
J
  • Solved
Search Multiple Columns for One Value
2
Replies
16
Views
625
Fluff
Fluff
S
  • Question
Pivot Table Where Data Has No Column Header
Replies
2
Views
220
shift-del
shift-del

Forum statistics

Threads
1,214,960
Messages
6,122,479
Members
449,088
Latest member
Melvetica

Share this page

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
Back
Top