Search

Need excel formulaReply
yes hyper is was:=COUNTIF($B$2:$D$8,G2)what do you suggest?How would I do it with the =rank?the countif formula counts well but it doesn't sort largest hits at the top on down......Here is the Countif results:DigitsHits04122334415261718291It counts but I wanted sorted so that the 0-3-2 is on top with 4 hits each and so on. If I remember, I think the rank would do it but don't know how to do it.Really what I am trying to do is set up a Power Trails spreadsheet.....fiddling with the amount of
Jan 14, 2006, 12:18 pm - Sandy K - Lottery Discussion Forum

Program or SpreadsheetReply
=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.
Feb 11, 2010, 9:31 am - pamelab - Lottery Discussion Forum

666Reply
Quote: Originally posted by hypersoniq on December 22, 2003 total STRAIGHT julian hits within 10 numbers from the rundown =108total BOX julian hits = 399250x108=$27,00040x399=$15,960 = total of $42,960to play from day 1$10x9141=$91,410 (must have played the 10, distribution of the 108 is near even, with a slight nod to the 2nd number in the rundown)net loss of $48,450...still one heck of a loss, $0.50 straight + $0.50 box bets assumed...last one in PA was september of this year, it was the 7th
Dec 22, 2003, 10:15 pm - hypersoniq - Lottery Discussion Forum

Program or SpreadsheetReply
Is the formula =countif(a1, 0 ) any help to you, or am I still missing what you are looking for?
Feb 14, 2010, 8:36 pm - pamelab - Lottery Discussion Forum

Excel users: What do you suggest? Learning resources.Reply
Funny thing I signed on to LP this evening to get help with Excel, I've used and studied excel for awhile now, but I am stuck. I created this large spreadsheet with all kinds of stats, but now I have been stuck for 2 days now on, example,Counting how many times a 0 follows a 0 , how many times a 1 follows a 0 , and etc. Well I thought I had the spreadsheet right because it is counting the pattern, but the horizontal digits 0-9 are reading the same as the verticle digits when the particular digit
Jan 5, 2010, 8:27 pm - pamelab - Lottery Discussion Forum

Need excel formulaReply
was it a =countif() formula?I have yet to try, but I think the =rank() formula could help with the order...
Jan 14, 2006, 12:09 pm - hypersoniq - Lottery Discussion Forum

Lottery Game PercentagesReply
hello= We'll do everything **in Excel**, step by step, so you can create a **matrix by position** and use the **percentages by position** in **Cash4Life 5/60** (or any 5/xx game). --- ## Objective Create in Excel: 1. A 60x5 matrix showing **how many times each number appeared in each position** (1st to 5th position, ascending). 2. Calculate **percentages by position**. 3. Use this to choose numbers and visualize hot and cold numbers by position. --- ## File St
Nov 3, 2025, 5:31 am - dr san - Lottery Discussion Forum

What methods do you use to eliminate non-winning combinations?Reply
OK so to better explain what we are really doing here we need to look at stastics. When we look at numbers that are less likely to come out we can see that this is something of a dice roll. How many times have you looked at hot and cold numbers only to notice that a cold number came out when the frequency count says it should not have come out because it come out less frequently than other numbers. So what are we left with that actually works? We need to look at some history of the game
Jul 4, 2022, 5:34 pm - lottologix - Lottery Discussion Forum

Program or SpreadsheetReply
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
Feb 14, 2010, 8:28 pm - pamelab - Lottery Discussion Forum

Program or SpreadsheetReply
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.
Feb 12, 2010, 11:37 am - pamelab - Lottery Discussion Forum