Pick 4 excel help please

Reply #12

jstewart26 — Tue, 26 Feb 2013 17:28:26 GMT

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

Reply #11

Mickie — Mon, 25 Feb 2013 09:35:37 GMT

TY, I will change to my date column

Have a great day

Reply #10

CARBOB — Mon, 25 Feb 2013 09:06:45 GMT

That's my date column

Reply #9

Mickie — Sun, 24 Feb 2013 16:29:16 GMT

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.

Reply #8

CARBOB — Sun, 24 Feb 2013 11:57:09 GMT

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.

Reply #7

Mickie — Sun, 24 Feb 2013 02:56:04 GMT

Reply #6

ranman17 — Sun, 24 Feb 2013 02:40:28 GMT

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

Reply #5

Mickie — Sun, 24 Feb 2013 01:54:19 GMT

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. Winsumloos... [ More ]

Reply #4

ranman17 — Sat, 23 Feb 2013 23:09:24 GMT

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

Reply #3

Mickie — Sat, 23 Feb 2013 22:42:34 GMT

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

Reply #2

jstewart26 — Sat, 23 Feb 2013 21:33:01 GMT

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

Reply #1

SergeM — Sat, 23 Feb 2013 19:46:59 GMT

There were many posts solving this problem without coding VBA.

Your solution is not okay.

Pick 4 excel help please

Mickie — Sat, 23 Feb 2013 13:30:51 GMT

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 bun... [ More ]