#### hypersoniq

##### Member

I have it laid out as such...

Column = Contents

A = Draw Number (sequential from 1 to 9,169)

B = Date of Drawing

C = the drawn combo (e.g. 251)

D = FIRST number drawn (2 from C)

E = SECOND number drawn (5 from C)

F = THIRD numberdrawn (1 from C)

What I would like to do is have the following skip table result...

pos 1 pos 2 pos 3

days days days

Number out out out

1 46 12 3

2 2 13 1

3 38 14 6

4 4 3 12

5 5 24 26

6 0 1 7

7 20 0 10

8 1 4 8

9 34 10 0

0 27 6 13

From this, I will take the top 3 by position, from the example above...

1 5 5 <longest out

3 3 0 <2nd longest out

9 2 4 <3rd longest out

As a formula or macro, I need something flexible enough to alter the ranges so I can perform back testing of this method of picking numbers (test for straight and box hits)... I already have formulas to test for straights and boxes, I need the formula (or at least an idea of how to go about solving this problem) to avoid the need to cover over 9,000 draws by hand.

Thanks in advance for any help ;-)