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

# Excel formula Even/Odd, Low/High Pattern, for Pick 5

Topic closed. 12 replies. Last post 3 years ago by helpmewin.

 Page 1 of 1

United States
Member #150473
December 23, 2013
14 Posts
Offline
 Posted: March 25, 2014, 10:51 pm - IP Logged

Hi,

By any chance someone have a the Excel Pattern formula for Odd/Even and Low/High  for

Pick 5 or pick 6 ??

LLLLL
LLLHL
LLLHH
LLHLL
LLHLH
etc,etc....

EEOOO
EOEOO
EOOEO

etc,etc....

I'm not an excel expert (that's why i'm looking for help) But i know a lil bit..

My problem is that my excel database and some others (many) formulas are

done for Pick 5 located
-."in Single cell"
-."Use dash between numbers" and
-. "low number (1 tru 9 ) use Lead zeroes".

example :

__Column G___ l __Column H__

01-02-03-04-05 l____________

_____________l____________

Please if any of you have such formula let me know, i'll appreciated a lot !!

P.S

The other day i posted a link to share my excel worksheet, but the lotterypost system

recognize me that i'm new to this forum and i can't post anything.. regarding of .. i don't remember

exactly the reason.. Mr todd mention it..

Sorry guy's

But keep on mind that if need formulas for same Single cell (Pick 3 to 6) and if i have

i'll share it with you.

Best regards from Miami

David

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Online
 Posted: March 25, 2014, 11:25 pm - IP Logged

Are you using the 2nd digits to calculate Low/High and Odd/Even?

For what lottery game

United States
Member #145207
July 31, 2013
94 Posts
Offline
 Posted: March 26, 2014, 1:32 am - IP Logged

United States
Member #150473
December 23, 2013
14 Posts
Offline
 Posted: March 26, 2014, 10:37 am - IP Logged

Hi WSLS,

This is for florida fantasy 5, and to be honest i didn't think it yet to calculate the whole number

for Low/High and Odd/Even, or 2nd Digit.. very interesting..

Best Regards

David

United States
Member #150473
December 23, 2013
14 Posts
Offline
 Posted: March 26, 2014, 11:06 am - IP Logged

Hi Basilio,

Thanks, and i'm sorry to bother with dumb question  .. but

my problem is That each Combination are in single Cell with "-' between digits

(not number on separte cell)

How do Change/replace for a single cell??, i know that it must have a "-" somewhere..
i'm still learning excel..

Best Regards

David

United States
Member #145207
July 31, 2013
94 Posts
Offline
 Posted: March 26, 2014, 1:04 pm - IP Logged

the easiest way would be by using excel test to columns

google "Split names by using the Convert Text to Columns Wizard",

United States
Member #150473
December 23, 2013
14 Posts
Offline
 Posted: March 26, 2014, 1:33 pm - IP Logged

Hi Basilio,

Yes, i know how to do the Test to column wizard, (and good suggestion)
but i can't apply the Wizard, because the other's Formulas, some groups of Macros and UDF's

are already Appplied for Single Cell, so,

if I do the Import wizard, these formulas, macros and vba become useless or have to be

re do it the whole worksheet.

Thank you so much, i appreciated a lot!!

Best Regards from Miami

David

United States
Member #123200
February 15, 2012
52 Posts
Offline
 Posted: March 26, 2014, 1:43 pm - IP Logged

Assuming your numbers are like this :  "01-04-12-33-50" in a single cell, the easiest way is to use Excel's "Text to Column" to split these out to seperate columns as was already suggested.  Or use:

 Original B1 B2 B3 B4 B5 O E L H 01-04-12-33-50 =INT(LEFT(A2,2)) =INT(MID(A2,4,2)) =INT(MID(A2,7,2)) =INT(MID(A2,10,2)) =INT(RIGHT(A2,2)) =SUM((ODD(B2:F2)=B2:F2)*1) =SUM((EVEN(B2:F2)=B2:F2)*1) =COUNTIF(B2:F2,"<28") =COUNTIF(B2:F2,">27")

Which would produce this:

 Original B1 B2 B3 B4 B5 O E L H 01-04-12-33-50 1 4 12 33 50 2 3 3 2

Note: I assumed that the highest # whiteball was 55, divided by 2 and assumed anything less than 28 was low and greater than 27 was high.

Also note that the formulas for "O" (odd) and "E" (Even) are array formulas and must be entered by pressing Shft-Ctrl-Enter after typing in the formula.

United States
Member #150473
December 23, 2013
14 Posts
Offline
 Posted: March 26, 2014, 2:47 pm - IP Logged

The formula to count the O/E, L/H, i already have it.

What i'm looikng is to apply the pattern, for pick5 in a single cell each number splitted by dash "-"

LLLLL
LLLHL
LLLHH
LLHLL
LLHLH
etc,etc....

EEOOO
EOEOO
EOOEO

etc,etc....

any way i have the starting point of the formula supplied by Basilio and i'm working on it..

Your Formula is another starting point as well, (appreciated !!!)

Thank you so much, every suggestions is welcome !!!

Best Regards

David

United States
Member #145207
July 31, 2013
94 Posts
Offline
 Posted: March 26, 2014, 3:08 pm - IP Logged

Hi Basilio,

Thanks, and i'm sorry to bother with dumb question  .. but

my problem is That each Combination are in single Cell with "-' between digits

(not number on separte cell)

How do Change/replace for a single cell??, i know that it must have a "-" somewhere..
i'm still learning excel..

Best Regards

David

good luck

United States
Member #150473
December 23, 2013
14 Posts
Offline
 Posted: March 26, 2014, 3:19 pm - IP Logged

Hi Basilio,

Thank you so much!!!!!!!!!!!!!!!!!!!!!!!!!

I'll share soon worksheet with all the filters that i'm using.(back testing)

I haven't finish..

Thanks !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Best Regards from Miami

David

bgonÃ§alves
Brasil
Member #92564
June 9, 2010
2125 Posts
Offline
 Posted: March 26, 2014, 6:58 pm - IP Logged

Hello, davidg, good job, ok you're only using the endings (last digit) of each number? Example 17 only using 7 ta? Yes because the initial digit of each number, from 49/6 going 0-4 since the endings 0-9. Those that are filtered (0-9), ie the digit in front of the number does not enter the study? You could see this pattern all along (six digits) xxxxxxou two (xx pairs). This study is good because they predict patterns, the digit that is in default or not?
It is a very good way of reduction, along with other filters digits

u\$a
United States
Member #106665
February 22, 2011
19884 Posts
Online
 Posted: March 28, 2014, 1:57 am - IP Logged

wow where you go

Let it Snow

 Page 1 of 1