Welcome Guest
You last visited December 6, 2016, 5:30 am
All times shown are
Eastern Time (GMT-5:00)

# Pick 4 excel help please

Topic closed. 12 replies. Last post 4 years ago by jstewart26.

 Page 1 of 1
Spring Lake
United States
Member #313
April 26, 2002
181 Posts
Offline
 Posted: February 23, 2013, 8:30 am - IP Logged

I have a number 1845

I would like if anyone has a formula to make this boxed (1458)

I have been using the morefunc & it works great but when
I go to other machines that doesn't have the morefunc on them it doesn't
come up.

Here is the pick 3 formula if anyone is interested:

=CONCATENATE((MIN(LEFT(I2),MID(I2,2,1),RIGHT(I2))),(MEDIAN(LEFT(I2),MID(I2,2,1),RIGHT(I2))),(MAX(LEFT(I2),
MID(I2,2,1),RIGHT(I2)))))

Replace the I2 for the cell of your choice :-)

Thanks bunches

Mickie

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: February 23, 2013, 2:46 pm - IP Logged

I have a number 1845

I would like if anyone has a formula to make this boxed (1458)

I have been using the morefunc & it works great but when
I go to other machines that doesn't have the morefunc on them it doesn't
come up.

Here is the pick 3 formula if anyone is interested:

=CONCATENATE((MIN(LEFT(I2),MID(I2,2,1),RIGHT(I2))),(MEDIAN(LEFT(I2),MID(I2,2,1),RIGHT(I2))),(MAX(LEFT(I2),
MID(I2,2,1),RIGHT(I2)))))

Replace the I2 for the cell of your choice :-)

Thanks bunches

There were many posts solving this problem without coding VBA.

United States
Member #133964
October 14, 2012
167 Posts
Offline
 Posted: February 23, 2013, 4:33 pm - IP Logged

help on wis lottery 4 for tonight   numbers last night 6089   tonight numbers to play???????????????????????

Spring Lake
United States
Member #313
April 26, 2002
181 Posts
Offline
 Posted: February 23, 2013, 5:42 pm - IP Logged

Sorry I really don't have any systems just yet. Just looking for a formula to make a Pick 4 number boxed.

The formula I posted is for a Pick 3 number boxed.

Good Luck

Mickie

New York
United States
Member #83026
November 27, 2009
2132 Posts
Offline
 Posted: February 23, 2013, 6:09 pm - IP Logged

I have a number 1845

I would like if anyone has a formula to make this boxed (1458)

I have been using the morefunc & it works great but when
I go to other machines that doesn't have the morefunc on them it doesn't
come up.

Here is the pick 3 formula if anyone is interested:

=CONCATENATE((MIN(LEFT(I2),MID(I2,2,1),RIGHT(I2))),(MEDIAN(LEFT(I2),MID(I2,2,1),RIGHT(I2))),(MAX(LEFT(I2),
MID(I2,2,1),RIGHT(I2)))))

Replace the I2 for the cell of your choice :-)

Thanks bunches

Are you looking for a way to put your 1845 in and have excel or a website show every permutation of that number?

Be kind, because everyone you meet is fighting a great battle.

An Unruly Evil

Spring Lake
United States
Member #313
April 26, 2002
181 Posts
Offline
 Posted: February 23, 2013, 8:54 pm - IP Logged

No, I am making a spreadsheet for the Pick 4 game like my Pick 3 spreadsheet. I took a picture, but can't insert here without posting to the net first.

Across is the date, P1, P2, P3, Day, Pk3, Box, Cfg(u-d-t), Cfg(Dbls)x2 columns 1st is Fp/Bp/Oe, 2nd is the actual Dbl(33)
Columns for the pairs, Vtracs, 3 columns for the Odd/Even cfgs, Sum, RtSum, Ldr.

The formula I posted was for the box column next to Pk3. I got it here years ago.
Now I am looking for a Pk 4 box formula. Winsumloosesum told me about the morefunc add on for excel that takes care of the boxing.
Problem is that I can only use it on my computer. If I try to open my files on another computer the formulas don't work for the box column.
I have never done alot with the Pk 4 but now I am looking into it again.

Thank you.

Mickie

New York
United States
Member #83026
November 27, 2009
2132 Posts
Offline
 Posted: February 23, 2013, 9:40 pm - IP Logged

No, I am making a spreadsheet for the Pick 4 game like my Pick 3 spreadsheet. I took a picture, but can't insert here without posting to the net first.

Across is the date, P1, P2, P3, Day, Pk3, Box, Cfg(u-d-t), Cfg(Dbls)x2 columns 1st is Fp/Bp/Oe, 2nd is the actual Dbl(33)
Columns for the pairs, Vtracs, 3 columns for the Odd/Even cfgs, Sum, RtSum, Ldr.

The formula I posted was for the box column next to Pk3. I got it here years ago.
Now I am looking for a Pk 4 box formula. Winsumloosesum told me about the morefunc add on for excel that takes care of the boxing.
Problem is that I can only use it on my computer. If I try to open my files on another computer the formulas don't work for the box column.
I have never done alot with the Pk 4 but now I am looking into it again.

Thank you.

There is a user here by the name of manual (look him up) he can probably put this on his site so that it can be used anywhere that you have an internet connection.  Here is his site: http://lottodrawodds.com/

Be kind, because everyone you meet is fighting a great battle.

An Unruly Evil

Spring Lake
United States
Member #313
April 26, 2002
181 Posts
Offline
 Posted: February 23, 2013, 9:56 pm - IP Logged

TY :-)

Mickie

ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
5896 Posts
Online
 Posted: February 24, 2013, 6:57 am - IP Logged

Ctrl-Shift-Enter

=SUMPRODUCT(SMALL(MID(BS17,ROW(\$BN\$1:INDEX(BN:BN,LEN(BS17))),1)+0,ROW(\$BN\$1:INDEX(BN:BN,LEN(BS17)))),10^(LEN(BS17)-ROW(\$BN\$1:INDEX(BN:BN,LEN(BS17)))))

Change BS17 to the the cell that 1845 is in.

Spring Lake
United States
Member #313
April 26, 2002
181 Posts
Offline
 Posted: February 24, 2013, 11:29 am - IP Logged

Thank you
Thank you
Thank you! Bunches :-)

I have been learning all the time.I am starting to figure this all out.
What is the ROW(\$BN\$1 used for? I don't have anything in that spot but was just wondering in case something should go there later.

Mickie

ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
5896 Posts
Online
 Posted: February 25, 2013, 4:06 am - IP Logged

Thank you
Thank you
Thank you! Bunches :-)

I have been learning all the time.I am starting to figure this all out.
What is the ROW(\$BN\$1 used for? I don't have anything in that spot but was just wondering in case something should go there later.

That's my date column!

Spring Lake
United States
Member #313
April 26, 2002
181 Posts
Offline
 Posted: February 25, 2013, 4:35 am - IP Logged

TY, I will change to my date column

Have a great day!

Mickie

United States
Member #133964
October 14, 2012
167 Posts
Offline
 Posted: February 26, 2013, 12:28 pm - IP Logged

wis lottery  pick 4 last night 1121  key patterns says  to play numbers 1,8,5,7,3,8,0,2   ????? wat numbers should i play  0718 sound good for tonight ???

 Page 1 of 1