Program or Spreadsheet

Reply #23

DMW774 — Wed, 17 Feb 2010 00:05:24 GMT

That worked PERFECTLY. Thanks so much for the help.

Reply #22

pamelab — Tue, 16 Feb 2010 19:55:14 GMT

After I copied your formula I have all three positions entered, thank you so much. Now I need to fix the spreadsheet so that as I enter new numbers the spreadsheet will calculate the new ranges. I might go back and try to do an absolute of the B column C column and D column.

Reply #21

CARBOB — Tue, 16 Feb 2010 17:42:22 GMT

The formula has to be enter like this, making sure the ranges are correct.

=SUMPRODUCT(--($B$2:$B$1499=F$2),(--($B$3:$B$1500=$E3

Reply #20

pamelab — Tue, 16 Feb 2010 15:53:19 GMT

Hi this formula is helpful to me also, but I have a problem, my excel will not let me enter the formula you have above, it will not recognize the , so when I enter the formula as this =sumproduct(--$d$3:$d$10000=T$1806)+(--($d$4:$d$10000=s1807)) this formula will only give me the value of 1 in the answer area. Do you have any idea what I am missing

Reply #19

DMW774 — Tue, 16 Feb 2010 03:26:22 GMT

This is EXACTLY what I'm looking for. However, I can't seem to get it to work on my spreadsheet. Assuming my list goes from B2 to B1500 (instead of B2 to B12, like yours), what is the exact formula I need to put in cell F3?

And thanks to all of you for your input.

Reply #18

pamelab — Mon, 15 Feb 2010 01:36:49 GMT

Is the formula =countif(a1, 0 ) any help to you, or am I still missing what you are looking for

Reply #17

pamelab — Mon, 15 Feb 2010 01:30:28 GMT

ok that just posted all wrong, maybe you can copy this to excel then do a text to column to get it entered into the right cells. Sorry I dont know how to get the spreadsheet to post here.

Reply #16

pamelab — Mon, 15 Feb 2010 01:28:21 GMT

I used the formula =countif($d$3:F:F, 0 )+Countif($d$3:f:f, =0 ) starting off with d3 is the beginning cell for the first drawn number in NC, through F cell representing the 3rd digit. I copied this formula throughout for each digit. I am not to sure of the exactness of this formula giving me the follow up numbers. However I do know it shows the 6 is followed up alot, and 6 is the most drawn digit. I am still working on this, and I will try the =match.

Number count(across)

Number drawn (do... [ More ]

Reply #15

pamelab — Mon, 15 Feb 2010 00:52:02 GMT

I am trying to post the spreadsheet in full but I am having a hard time pasting to website.

Reply #14

Raven62 — Sun, 14 Feb 2010 14:33:11 GMT

Thanks for sharing!

Are you using a Matrix for the results? Each axis would have 0 9

Then using =match and =countif in each cell of the matrix would provide the count

Reply #13

ca-dreamin* — Sun, 14 Feb 2010 14:27:42 GMT

Don't feel bad I have Exel on my computer and I even found an easy tutorial to follow.......LOL and when I finally win the lottery maybe I'll have the time to actually sit down and figure out how to use it. For now everything is paper and pencil.

Reply #12

GASMETERGUY — Sun, 14 Feb 2010 12:32:01 GMT

After entering all your numbers by hand, you can sort the column. Look to the far

right side of the tool bar (the very top of the page). You will see AZ. This is your

sort button. Click on the cell of the column (such as A1), then click on AZ. All the columns will line up

numerically and you can see which numbers follow what. This will not work if you

have a blank column between the numbers. Keep all the numbers in adjacent cells.

Reply #11

CARBOB — Sun, 14 Feb 2010 12:23:53 GMT

The image is only for position 1, the formula below is telling how many times the digits going across have followed the digits going down, for position 1 only. The others will have to be created, by changing the ranges.

=SUMPRODUCT(--($W$14:$W$115=AC$14),(--($W$15:$W$116=$AB15

Reply #10

pamelab — Sun, 14 Feb 2010 04:06:31 GMT

Please don't feel that way, I responded in a quick way thinking the other person was familiar with the formulas for excel, I am still learning Excel myself. I was hoping to put our heads together so we can figure out a formula for myself.

Reply #9

DMW774 — Sat, 13 Feb 2010 10:31:43 GMT

Entering the cells I want to look at seems kind of silly. I want to look at all of them. I want to see which numbers come after eachother. If I only wanted to see what comes after 1, I would still have to look over the whole thing to find the cells with 1 in them. I may as well do that by hand.

As for the use of countif formulas, I am not familiar with that. I will see if I can find something close to what I'm looking for and get back to you. Thanks.

Reply #8

DMW774 — Sat, 13 Feb 2010 10:23:21 GMT

Open a spreadsheet and start at A1, typing a number between 1-8, and hit Enter each time, so that everything stays in column A. That would make a pretty close approximation of my worksheet.

Reply #7

CARBOB — Fri, 12 Feb 2010 17:19:34 GMT

Can you post an image of the worksheet

Reply #6

tiggs95 — Fri, 12 Feb 2010 17:11:39 GMT

I read some of these post like this and have no idea what they mean then someone says they will clarify it for you and that makes it even worse..I feel so dumb reading some post..Beam me up Scotty..Good luck is what it is in the end..

Reply #5

pamelab — Fri, 12 Feb 2010 16:37:48 GMT

I understand what you are saying, I am still working on something similar, where you track the digit that follows a certain digit. Could'nt you enter the cells you desire in this formula? I got this formula from typing in 'formulas for Excel or countif formulas in the google search bar.

Reply #4

DMW774 — Fri, 12 Feb 2010 06:13:54 GMT

Any websites out there that deal specifically with using Excel for the purpose of gathering stats on the lotto/lottery

Reply #3

DMW774 — Fri, 12 Feb 2010 06:12:38 GMT

Perhaps I should clarify. I took the first column of my local pick 3 and determined whether each number was high or low, even or odd, and had a skip above or below 6. I then assigned each circumstance a number. So, if it is a high, odd number with a skip ABOVE 6, it was assigned one number, but if it is a high, odd number with a skip BELOW 6, it was assigned a different number. Hence, my list is entirely within column A, in Excel.

What I need to know is what numbers follow eachother on such a... [ More ]

Reply #2

Todd — Thu, 11 Feb 2010 16:40:03 GMT

Excel is great for these kinds of things, because you don't need 10,000 different software packages, each with their own errors and quirks and features. Excel is a lottery player's best friend.

If you don't know how to work with numbers, combos, and digits in Excel, then learn! There are tons of books on the market, and all you have to do to get started is fire it up and start playing around.

Plus, it comes with lots of built-in help and tutorials, and the Microsoft site has lots of great... [ More ]

Reply #1

pamelab — Thu, 11 Feb 2010 14:31:24 GMT

=COUNTIF($D$3:$F:$F, =0 )+COUNTIF($D$3:$F:$F, =1 ) I am still working on this formula myself. $D$3:$F:$F is the columns I entered the drawn digits in.

Program or Spreadsheet

DMW774 — Thu, 11 Feb 2010 14:09:26 GMT

I have a list of numbers and I need to know how many times each number is followed by all the other numbers (or the same number). In other words, I need to know how many times 1 is followed by 1, how many times 1 is followed by 2, how many times 1 is followed by 3, etc.

Thanks