formulas

New Contributor

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.

3 Replies
I think you could use this in row 3
=Match(A2,B2:Z2,0)
and then copy/fill right
that will give you "how many cells to the right is this same number (assuming it will happen in less than 25)
Then you create a table for Averages lets say it is in the range A10:B13:

1 =averageifs(3:3,2:2,$A10)
2
3
4
and fill down

@mtarler  here is attached sample and I updated a couple formulas for error conditions

thank you for your very quick response. i will try this out tomorrow.