Another lottery question

anon125

Active Member
Joined
Feb 14, 2008
Messages
392
How do i with excel 2002 determine if all 6 lottery numbers have been won more than once?
Same for 5 of 6 numbers.
As you know the data increases after every draw. So naming the data field has to accommodate this.
Thanks all
 
Also,

Nobody anywhere has an excel solution. As I stated, the lottery data is changed so often to thwart that type of solution. If there was an excel solution, everybody would be using it.

If you want to look elsewhere, you can stop posting in this message and actually look elsewhere. Nobody is stopping you. Feel free to browse the internet. You might try a gamblers forum or a lottery forum.
 
Upvote 0

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

You are right according to lottery side.​
But according to its Excel data some well known solutions already exist and as a reminder, solutions belong to good enough readers …​
 
Upvote 0
I don't think "arcane" means what you think it means.

ar·cane
/ärˈkān/
adjective
understood by few; mysterious or secret.

The rules are literally posted on every message board, everywhere.
sad that you know more about arcane that the excel solution.
 
Upvote 0
Not as sad as your response. I look up the definitions of words I'm not familiar with before using them. I don't berate those who know more than me, especially if I'm asking for help from them at the same time.
 
Upvote 0

Forum statistics

Threads
1,214,392
Messages
6,119,257
Members
448,880
Latest member
aveternik

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