Mar 17 2022 11:03 AM
The numbers below this sentence represent days i,e in this case 1 to 30 which could go up to 1340 days
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
1 1 2 3 4 7 2 1 4 2 3 1 3 2 5 4 1 1 8 1 2 3 4 3 3 4 3 2 2 ??
The numbers above this sentence represent a result that has come out on the day in question.
Is there a formula that would take into account the numbers in the second row that have already come out whilst also taking into account how many days apart they have come out and hopefully display a result as to what number would likely be the next one to pop up? if not what number, maybe what numbers as in maybe the numbers 1 or 3 could possibly come out.
Mar 17 2022 11:48 AM
Mar 17 2022 11:59 AM
@mtarler here is attached sample and I updated a couple formulas for error conditions
Mar 17 2022 12:43 PM