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?