Excel sequence number generator

[MCSAEddie]

Hello everyone, I'm new here just joined today. Happy to be a part of this forum.

I have a question if someone can answer it please!
Can excel determine the series of two digit numbers if I place them down a column? Now these numbers can be any random two numbers from 01 - 50 or so.
So if type down column "A" these numbers 10, 05, 20, 29, 06, 25, 01, 02, 09 and 37 at the bottom - could Excel look at these numbers at determine the next number at the bottom based on the series?
Now this is only a set of ten numbers. I may want to try this with a few hundred rows down. Not sure if Excel has a limit on how many rows it can determine. This may be a stupid question or not but had to ask.

Any help is greatly appreciated!!!
Thanks, Ed

[martindwilson]

no.................................
what would you think the next number would be? series have to have a logical reason
even a logical sequence could have more than one outcome
1,2,3 what comes next?
you could say 4 as its the previous number +1
or it could be say 5 as its the sum of the previous 2 numbers
and probable some other sequences as well

[ChemistB]

If you have a logical pattern and you select enough cells for Excel to see it, then sometimes Excel will continue the pattern
For example, 3,9, 15 will continue 21, 27, 33,39,45 (for i = 1 to n i * 3)
or 31,26, 21 continues 16, 11, 6, 1

As Martin said, sometimes Excel sees a different pattern than what you wanted it to see.

[MCSAEddie]

First thing thank you Martin and ChemistB for your responses to my question.
I understand what both of you are saying. There has to be some type of pattern already in place not just any random number.
I wasn't sure if I were to highlight all the numbers in that column and drag them down by the lower right hand corner in order to get the next number?
I also wasn't sure if there was a formula in Excel for this and that's why I had to ask you guys.

Thanks so much guys!

[ChemistB]

No problem. There is no formula.