lottery

Ok, so the title might be confusing. I play the lottery a little bit. What I am trying to calculate is the end date based upon the number of drawings I purchase. Taking the two everyone is most familiar with Powerball and Mega Millions If I purchase tickets today(2/8/15) for four draws on...

At work we run a lottery bingo where 30 people pick 6 numbers each from a total of 30 numbers, the easy bit is highlighting a persons number when one is drawn using conditional formatting but I need to highlight a person if they have absolutely no chance of winning the game due to other people...

I have downloaded an xls spreadsheet with the past powerball winning numbers. I want to use this data set and find out every combination of numbers that add up to a certain total, for example 160. I do not know how to go about doing this, without writing huge, nested if then statements and...

I am trying to do my own and personal lottery analysis. One of the things I have is four sections of 6 columns each, 11 rows down. All these filled with different and reapeated numbers from 1 to 60. What I want, is to have Excel pick out the repeated numbers and give me a count of those. I have...

Hello, wondering if anyone can help have been stuck at this for a few hours and is doing my brain in :) Ive got some lottery numbers I'm starting to use on a regular basis but noticed on the web I could get a copy of previous results and thought it would be good to see if they had come up in...

In Excel 2010, I want to sort the lottery numbers (Balls 1 -4) numerically (as it shows in NewBall 1-4). Note that I do NOT want them concatenated into one column, as I need them to remain separate. What do you recommend? <table rules="all" style=";background-color: #FFFFFF;border: 1px...

Hi, Everyone. I am the commissioner of a Fantasy Hockey league. At the end of the season, the lowest 7 players will have an opportunity to be placed in a draw to determine the drafting order for the following year. The player that finishes last will have the highest odds of getting the #1 pick...

Given the min and max values from historical data. Can excel calculate the probability of the next number?

I have 6 columns of numbers and I want to generate a random number in each column, but I want to restrict each column to a set range of numbers. Think of it like a lottery with total numbers 1-39, but since only certain numbers are the most likely to come up (say in column 1 only numbers 1-10...

Hello! I am just about to begin being in charge of a lottery syndicate. It's for the UK Lotto if that makes any difference. I am looking for a nifty spreadsheet that I can enter the 6 winning numbers into and have it tell me if we have matched any numbers against our lines. I have tried to...