excel formula ? to show what number came out after a winning number

For Pick 3 or Pick 4, each digit of the winning number is in its own column.
For Pick 5 game, each of the five numbers is in its own column.
Let's say with a Pick 5 game, #10 fell in tonight's game in the 2nd numerical position (2nd column). What I want to find is what number came out after #10 in the 2nd position/column of all previous games. Is there a formula I can type in to give me this info?
All I know how to do right now is to use the AutoFilter to find the dates that #10 fell in the 2nd position/column, copy the dates, then look at the whole list to see what numbers fell "after" the dates that #10 was drawn. I'm wondering if there's an easier way to arrive at the info I want.

There is a more complicated way.

Let's say with a Pick 5 game, #10 fell in tonight's game in the 2nd numerical position (2nd column). What I want to find is what number came out after #10 in the 2nd position/column of all previous games.

Is there a formula I can type in to give me this info?

All I know how to do right now is to use the AutoFilter to find the dates that #10 fell in the 2nd position/column, copy the dates, then look at the whole list to see what numbers fell "after" the dates that #10 was drawn. I'm wondering if there's an easier way to arrive at the info I want.

Using worksheetfunctions for pick 5:

Use one column next to the data for the output, enter a function to return the second number if the previous datarow contained number 10 at ordinal position 2.

PICK3 BE

COUNT: TRAILER T/F BY LINE

WITH VBA

You don't sum up dates, so that would be a list on the other side.

If you specialize: number occurs 1 time, trailer occurs 1 time, then you get a different result.

Indeed you find strange stuff when you define how many times the number and trailer should occur.
So I found here for number 3 times and trailer 3 times the following table.

I did a test and it is true. It happened:

So I don't know if your post is related to the results of Pick 3 of Belgium.

N*2 AND T*2

And so on.

I suppose that your view at it is sequential.

Topic sounds nice...

My data input above was wrong above, but the functions work. It was my exercise file.

I need a break from this.

Is this what you are looking for?  LDP1= Last draw p1; NDP= next draw p1' you will have to do this for each postion.

formula in Hits column= change the ranges for your workbook.

=SUMPRODUCT(--('HOT-COLD'!$B$8:$B$4000=$AF$7),--('HOT-COLD'!$B$9:$B$4001=$AG7))

formula for  skips, enter as array formula, Ctrl-Shift-Enter!!!

=CHOOSE(IF(N($AH7),IF(COLUMNS($AM7:AM7)=1, 1, IF(COLUMNS($AM7:AM7)<=$AH7,2,3)),3),SMALL(IF('HOT-COLD'!$B$8:$B$4000&"@"&'HOT-COLD'!$B$9:$B$4001=$AF$7&"@"&$AG7,ROW('HOT-COLD'!$B$8:$B$4000)-ROW('HOT-COLD'!$B$8)),1),SUM(SMALL(IF('HOT-COLD'!$B$8:$B$4000&"@"&'HOT-COLD'!$B$9:$B$4001=$AF$7&"@"&$AG7,ROW('HOT-COLD'!$B$8:$B$4000)),{1,0}+COLUMNS($AM7:AM7)-1)*{1,-1}),"")

Using just a short span of winning numbers here, rather than all of them:

5/31/12 ==  5    10    13     26    34
6/1/12  ==   2    13    14    29     33
6/2/12  ==   1     4     35    36     39
6/3/12  ==   1     2      7      8     28
6/4/12  == 13    16    17    19     34
6/5/12  ==   5    12    32    33     39
6/6/12  == 13    20    25     31    38
6/7/12  == 11    15    16    21     38
6/8/12  ==  3      9    12     27     35
6/9/12  ==  1      3     7     17      20
6/10/12 ==  7    10    20    24     38
6/11/12 ==  7     8      9     11     35
6/12/12 == 12    17    18    31     36
6/13/12 ==   2    24    26    28     29
6/14/12 ==   2     9     10    11     26
6/15/12 ==   1    11    20    24     33
6/16/12 ==   5    13    16    22     27
6/17/12 ==   1    18    23    24     29
6/18/12 ==   3     7    19     21     36
6/19/12 ==   2     6     7     11      24
6/20/12 ==   2     6    23    28      35
6/21/12 ==   1    11    13    20     27

#10 fell  in the second position on 5/31/12 and on 6/10/12.  Numbers 13 and 8 came out after the #10.

So, in doing what you suggest, 13 and 8 (and more when I do the whole set of winning #s) will show in the results?

Thanks.

good gosh carbob!!!

You will need to sort the draws, new to old, for formulas to work correct.

Gee, I'm sorry, but none of these suggestions sounds like the info I'm looking for. I'm not interested in pick 3, skips, hits, avg, med, max, due, odd/even, or frequency. Let me rephrase what I'm wanting, hope that Excel can perform it, and someone knows how to get the results for me.

Winning Lotto numbers are in numerical order, with numbers in their respective columns. If I want to search the 2nd number column for the number/value contained in the next cell directly below a given number/value, say 10, is there a formula I can type in that will lookup all the values of 10 but only show me the next cell below each value of 10?

Column A is the date of the drawing.

Column B is the first number in numerical order.

Column C is the 2nd number in numerical order. 10 is in Column C, with Row numbers of:

24, 53, 61, 76, 78, 106, 111, 134, 143, 153, 156, 184, 191, 202, 214, 226, 248, 284, 338, 345, 401, 410, 413, 425, 438, 448, 455, 508, 515, 542, 552.

But I'm wanting results to show what is in the next cell below each #10, so I want a formula to show me Rows:

25, 54, 62, 77, 79, 107, 112, 135, 144, 154, 157, 185, 192, 203, 215, 227, 249, 285, 339, 346, 402, 411, 414, 426, 439, 449, 456, 509, 516, 543, 553.

Is there a way to get Excel to show me this information?

Put your function next to the outer right column, like told above.
If you want a list, you need to add a column for concatenation.
Maybe there is a complicated array function for this, I don't go that far because I use the VBE.

So, yes, it is possible.