Welcome Guest
You last visited December 8, 2016, 1:03 pm
All times shown are
Eastern Time (GMT-5:00)

# excel formula needed

Topic closed. 12 replies. Last post 12 years ago by Littleoldlady.

 Page 1 of 1
Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: January 29, 2005, 9:53 pm - IP Logged

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?

L ttaL   T

roseville, MI
United States
Member #5980
July 30, 2004
18205 Posts
Offline
 Posted: January 29, 2005, 10:12 pm - IP Logged

Lottaloot I would ask Sandy She's the excel wizard

ALL IN!

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: January 29, 2005, 10:19 pm - IP Logged

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

L ttaL   T

Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
 Posted: January 30, 2005, 9:04 am - IP Logged

Here is what I have

Assuming 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)

Playing more than one ticket per game is betting against yourself.

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: January 30, 2005, 11:03 am - IP Logged

Thanks Hypersoniq.

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

L ttaL   T

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: February 10, 2005, 1:00 am - IP Logged

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?

L ttaL   T

CA
United States
Member #2987
December 10, 2003
832 Posts
Offline
 Posted: February 10, 2005, 1:16 am - IP Logged

try the functions available with "=FREQUENCY"

gl

j

Blessed Saint Leibowitz, keep 'em dreamin' down there.....

Next week's convention for Psychics and Prognosticators has been cancelled due to unforeseen circumstances.

=^.^=

East of Atlanta
United States
Member #6191
August 11, 2004
1389 Posts
Offline
 Posted: February 10, 2005, 1:03 pm - IP Logged

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 are only counting individual numbers with no regard to what day of the week:

=COUNTIF(Cash3History!D2:D4500,U4)

D2:D4500 contains the number (single position with this example)

U4 contains the number in the chart I am interested in.

Sir Metro

Poway CA (San Diego County)
United States
Member #3489
January 25, 2004
14120 Posts
Offline
 Posted: February 10, 2005, 1:10 pm - IP Logged

I'm looking for a formula that will give me the winning number of the next draw (straight).  PLEASE!!!  LOL

Thanks to all that took the time to answer the questions about formulas.

East of Atlanta
United States
Member #6191
August 11, 2004
1389 Posts
Offline
 Posted: February 10, 2005, 1:29 pm - IP Logged

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 Metro

One's viewpoint of life is all that matters in the end.

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: February 10, 2005, 2:39 pm - IP Logged

Thanks

L ttaL   T

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: February 10, 2005, 2:43 pm - IP Logged
Quote: Originally posted by SirMetro on February 10, 2005

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 Metro

One's viewpoint of life is all that matters in the end.

Too funny!!!!!

L ttaL   T

Clarksville
United States
Member #487
July 15, 2002
17638 Posts
Offline
 Posted: February 13, 2005, 8:49 am - IP Logged

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?

If you know your number is going to hit, have patience and then KILL IT!

You never know when you will get another hit.

 Page 1 of 1