Search

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 an excel routine for comparing numbers from row to rowReply
I'd use the if statement above and also the countif function. There is a video on youtube, look for Excel Magic Trick #180 for the countif function.
Jan 30, 2009, 3:49 pm - haveagreatday! - Mathematics 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

Need help with workout....Reply
Deb, Put this formula in V6, then copy across, then down. =COUNTIF($G$3:$J$3,G6)Carbob
Oct 26, 2005, 7:44 pm - CARBOB - Pick 3 Forum

A 2 digit return in Pick 3...how often do you say?Reply
All formulas go in the top left of their respective sections and can be copied across and down: Vtracs: Code: =IF(R88= , ,--RIGHT(R88+5,1)) Odd: Code: =IF(ISODD(R88),R88, ) Even: Code: =IF(R88= , ,IF(ISEVEN(R88),R88, )) Repeaters: Code: =IF(R88= , ,IF(OR(COUNTIF($R87:$U87,R88) 0,COUNTIF($R89:$U89,R88) 0),R88, )) Leap Frog (couldn't figure out your formatting): Code: =IF(R88= , ,IF(OR(ISNUMBER(MATCH(--RIGHT(9+R88,1),$R87:$U87,0)),ISNUMBER
Jul 24, 2014, 5:02 pm - dr san - Mathematics Forum

Can Excel do this?Reply
to get a list count of all the pairs in column e1 thru e100 enter 00 thru 99 (to get a leading zero, from the top menu go to format/cells/number/custom and enter 00) let's assume you have 9000 numbers in f1, enter =countif($B$1:$D$9000,E1) then drag it down to f100 this will count ALL of the pairs without differentiation if you want to count all pairs and determine front pair/back pair/bookends... in f1 (for front pair) =countif($B$1:$B$9000,E1) in g1 (for back
Apr 3, 2007, 5:39 am - hypersoniq - Lottery Systems Forum

Need some help with excel counting verticalReply
Hope this help, how many 2s =COUNTIF(A2:A13,2) x2 how many 1s =COUNTIF(A2:A13,1) x1 how many 5s =COUNTIF(A2:A13,5) x5
Apr 4, 2014, 11:23 pm - basilio - Mathematics Forum

pick3Reply
With this and your follow-up postings, you did a job of clarifying what you are doing. Unfortunately, there is still one very important detail that is unclear to me. Your original question was how to do some things in Excel. So at this point, I would like to refer you to an uploaded Excel file that might clarify my comments below. But I am still just a new member , and the draconian rules of this forum do not permit me to post a URL or even an email address to contact me directly. I will d
Sep 11, 2012, 11:50 pm - mathhead - Lottery Systems Forum

Excel 2010 HelpReply
Here is how I do it which means you should look for other ways. I highlight the area in which I want to know how many numbers? I then click on the name manager button and give this highlighted area a throw-a-way name, such as temp1 . I click on the cell which will contain the data I am seeking. Using the countif function, I enter this code, = countif(temp1,23) . Excel will then tell me how many times 23 came up within the area I so named.
Feb 23, 2014, 7:39 am - GASMETERGUY - Lottery Systems Forum