excel formula needed

Reply #12

Littleoldlady — Sun, 13 Feb 2005 13:49:21 GMT

My question has 3 parts....part 1: How can I use excel to find all three digits that fell behind a particular number..? (pick 3)part 2: how do I set up a database in excel? (I'm still using 98)part 3: Is there anyway to highlight the numbers so I can see them

Reply #11

lottaloot — Thu, 10 Feb 2005 19:43:14 GMT

Quote: Originally posted by SirMetro on February 10, 2005Formula I use for each and every winning number produced by all lotteries,Take all the cash I had intended to spend on the lotteries to the local liquor store, find the biggest bottle of crown royal select that the money in my hand can buy and pocket the change. Go home, pour myself a (ok a glass full) in my nice monogramed crown royal cup, kick back and day dream of what it would be like to actually win big while that nice alcoholic buzz

Reply #10

lottaloot — Thu, 10 Feb 2005 19:39:21 GMT

Thanks

Reply #9

SirMetro — Thu, 10 Feb 2005 18:29:21 GMT

Formula I use for each and every winning number produced by all lotteries,Take all the cash I had intended to spend on the lotteries to the local liquor store, find the biggest bottle of crown royal select that the money in my hand can buy and pocket the change. Go home, pour myself a (ok a glass full) in my nice monogramed crown royal cup, kick back and day dream of what it would be like to actually win big while that nice alcoholic buzz sets in.I win every time that way ;-)Sir MetroOne's viewp... [ More ]

Reply #8

CalifDude — Thu, 10 Feb 2005 18:10:23 GMT

I'm looking for a formula that will give me the winning number of the next draw (straight). PLEASE!!! LOLThanks to all that took the time to answer the questions about formulas.

Reply #7

SirMetro — Thu, 10 Feb 2005 18:03:40 GMT

I use the formula below to count how many times a number occurs on a given day=SUMPRODUCT(--(Cash3History!A2:A141=V38),--(Cash3History!D2:D141=U39))A2:A141 contains a reference to day of the week (Sun thru Sat)V38 contains the day I am currently interested in (Sun thru Sat)D2:D141 contains the numbers I am looking at (single position)U39 contains a reference to the number I am looking for.=========================================================Also, you could use the following formula if you ar... [ More ]

Reply #6

johnph77 — Thu, 10 Feb 2005 06:16:59 GMT

try the functions available with =FREQUENCY glj

Reply #5

lottaloot — Thu, 10 Feb 2005 06:00:10 GMT

If anyone knows a formula that will give a total return number of how many times 0 thru 9 appears in a chart, could you please post it here? Thanks in advance

Reply #4

lottaloot — Sun, 30 Jan 2005 16:03:55 GMT

Thanks Hypersoniq. I think I found the above formulas in one of your previous posts.

Reply #3

hypersoniq — Sun, 30 Jan 2005 14:04:57 GMT

Here is what I haveAssuming Cell C is where you enter the 4 digit combo...in cell D ... =INT(C2/1000)in cell E ... =INT((C2-(D2*1000))/100)in cell F ... =INT((C2-((D2*1000)+(E2*100)))/10)in cell G ... =INT((C2-((D2*1000)+(E2*100)+(F2*10))))(i have draw date and draw number in columns A and B

Reply #2

lottaloot — Sun, 30 Jan 2005 03:19:15 GMT

Thanks. She's offline at present though so if anyone else knows please post

Reply #1

undress — Sun, 30 Jan 2005 03:12:45 GMT

Lottaloot I would ask Sandy She's the excel wizard

excel formula needed

lottaloot — Sun, 30 Jan 2005 02:53:16 GMT

I have the following formula to set up for 3 digit using pos1, pos 2, and pos 3=INT(B2/100)=INT((B2-(C2*100))/10)=INT((B2-((C2*100)+D2*10)))Can anyone tell me what formula I would add to do my 4 digit data in this manner