#### hypersoniq

##### Member

Formula for Up-Down...

=IF(C2<C3,"U",IF(C2=C3,"x","D"))

Formula for Decades

=IF(C2>49,6,IF(C2>39,5,IF(C2>29,4,IF(C2>19,3,IF(C2>9,2,1)))))

Formula for Even-Odd

=IF((C2/2)-(INT(C2*0.5))=0,"E","O")

Counting times a number was drawn...

1. number 1 to 53 down a column, using the first cell for a label (for example column AD)

2. enter this into cell AE2...

=COUNTIF($C$2:$H$76,AD2)

3. autofill down to 53

4. enter the following in cell AF2...

=COUNTIF(C$2:C$76,$AD2)

5. autofill across to column AK

6. autofill columns AF thru AJ down to 53

7. autofill column AK down to 42

this gives times a number was drawn and breaks it down into what position (SORTED)

my sheet is set up with the following columns...

A = Draw Date

B = Draw Number

C = White Ball 1 (SORTED order)

D = White Ball 2

E = White Ball 3

F = White Ball 4

G = White Ball 5

H = PowerBall (Red)

also: sum, sum+powerball, day of draw (W or S), powerplay, jackpot value and # of winners in each prize tier

The formulas are designed to exploit autofill, only need to type once

I have a question... what are they good for? How can you use the results to help in making your pick?

Is it just meant as a guide or is there some way to apply this with precision? I'm relatively new to all of this...